SQL Exception in Schema Script Generator in Cloudera, as there are no indexes

To reproduce:

1. Create a new Cloudera Server and Connect using Cloudera by copying the cloudera jdbc drivers from the original distribution

2. Connect to a Cloudera Database with Tables.

3. Open Help > View Log. Select a database, right Click and use Tools-> Schema Script Generator.

4. Save as : Preview Tab

5. Select "Generate the CREATE" and hit next

5. You can see that the  script is generated successfully, but you get the below exception, since there are no indexes for Cloudera.

 

java.sql.SQLException: AnalysisException: Syntax error at:

SHOW INDEX ON `t99` FROM `tomtestagain`

     ^

Encountered: IDENTIFIER

Expected: DATABASES, SCHEMAS, TABLES

 

CAUSED BY: Exception: Syntax error

        at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:162)

        at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:150)

        at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:196)

        at org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:262)

        at \\...\\ .\\हिñçêČάй語简??한\\.fꀃ⣨᠇̷.executeQuery(Unknown Source)

        at com.aquafold.aquacore.open.rdbms.drivers.hive.xꍫꑔꎜꃥ.executeQuery(Unknown Source)

        at \\...\\ .\\हिñçêČάй語简??한\\.fꀃ⣨᠇̷.executeQuery(Unknown Source)

        at \\...\\ .\\हिñçêČάй語简??한\\.bꆟꁽꈦꀋ finally.a(Unknown Source)

        at \\...\\ .\\हिñçêČάй語简??한\\.Lꑵᢖ⣹⣲.a(Unknown Source)

        at \\...\\ .\\हिñçêČάй語简??한\\.bꌀꋊᛜꏦ do 4.c(Unknown Source)

        at \\...\\ .\\हिñçêČάй語简??한\\.bꌀꋊᛜꏦ do 4.b(Unknown Source)

        at \\...\\ .\\हिñçêČάй語简??한\\.bꌀꋊᛜꏦ do 4.run(Unknown Source)