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)
Same issue as above with Schema Compare (Select 2 database, right click and select option Schema Compare) gives you the above SQL exception.
Issue #11857 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 14.0.10-5 |
No time estimate |
1 issue link |
relates to #11856
Issue #11856SQL Exception when you generate ER Diagram in Cloudera, as there are no indexes |
Same issue as above with Schema Compare (Select 2 database, right click and select option Schema Compare) gives you the above SQL exception.