× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2014-03-25T20:04:18Z  · last modified 2014-04-01T22:34:37Z

SQL Exception when you generate ER Diagram in Cloudera, as there are no indexes


Priority Low
Complexity Unknown
Component Hive
Version 14.0
Version: 14.0.10-2
Build #: 36815
Build Date: 2014-Mar-20 04:49:36 PM
 

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)

 

2 attachments

Issue #11856

Closed
Fixed
Resolved 2014-04-01T18:34:51Z
 
 
Completion
No due date
Fixed Build ADS 14.0.10-5
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017