SQL Exception in Query Builder when you add a table

To reproduce:

1. Open Help > View Log.

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

3. Connect to a Cloudera Database with Tables.

4. Open a Query Builder

5. Add a table

You can see that the table is added 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)