SQL Exception when you generate ER Diagram 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-> ER Diagram Generator.

4. Select all options in the window - Include Full Table (Indexes) must be selected

5. You can see that the  ER Diagram 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 \\...\\ .\\हिñçêČάй語简??한\\.bꆟꁽꈦꀋ finally.a(Unknown Source)

        at \\...\\ .\\हिñçêČάй語简??한\\.jꉯꎮ⢂ꆅ.b(Unknown Source)

        at \\...\\ .\\हिñçêČάй語简??한\\.zꀰꀛꅘꆃ.process(Unknown Source)

        at com.common.ui.util.BackgroundThread.run(Unknown Source)