Aqua Data Studio 15.0.0-dev-295
Build #: 38083
Built on: 2014-May-22 04:40:25 PM
Operating Environment: Ubuntu 13.04 LTS
Database: Cloudera Impala
CDH 5 VM , Connection Type: Impala , Port: 21050
Java Version: Java 1.7.0_51
Issue: Impala- Shows Analysis Exception on generating Create Table script
Steps to reproduce:
Start Cloudera Quickstart VM CDH5 [or you can use other Cloudera version ]
1. Register Servers with below credentials
a] To Register Impala Server:
Name: HS2CDH5Impala
Connection Type: Impala
Port : 21050
2. Open Query Analyzer and run below Query to create a Database and Table,
CREATE DATABASE dbimpala
GO
CREATE TABLE `dbimpala`.`testdatatypes1gui` (
c1bigint bigint,
c2boolean boolean,
c3double double,
c4float float,
c5int int,
c6real real,
c7smallint smallint,
c8string string,
c9timestamp timestamp,
c10tinyint tinyint)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
STORED AS TEXTFILE
GO
3. Right click on Table "testdatatypes1gui" , from pop-up select "Script Object to Window As" ->CREATE
or select "Script Object to Window As" ->CREATE (Full)
4. Create script gets generated in query Analyzer, but it also shows exception: [Refer screenshot CDH5Impala-dev295.png]
java.sql.SQLException: AnalysisException: Syntax error in line 1:
SHOW INDEX ON `testdatatypes1gui` FROM `dbimpala`
^
Encountered: IDENTIFIER
Expected: AGGREGATE, COLUMN, CREATE, DATABASES, FUNCTIONS, SCHEMAS, TABLE, TABLES
CAUSED BY: Exception: Syntax error
at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:167)
at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:155)
at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:210)
at org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:333)
at com.aquafold.aquacore.open.rdbms.drivers.hive.tꂬꏊꃗᝍ byte 10.executeQuery(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Pᚦꎏᠰꈏ void.executeQuery(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.c͙ꈊᜫᡒ goto synchronized.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.c͙ꈊᜫᡒ goto synchronized.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.c͙ꈊᜫᡒ goto synchronized.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.c͙ꈊᜫᡒ goto synchronized.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Mꂴꌅꐧꀴ.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Mꂴꌅꐧꀴ.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.s⡚ꁃᛔᚦ.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.zꁭ⣦ꆍᝄ void public.a(Unknown Source)
at com.aquafold.datastudio.mainframe.ActionHandler.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.AbstractButton.doClick(AbstractButton.java:376)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)
at java.awt.Component.processMouseEvent(Component.java:6505)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3320)
at java.awt.Component.processEvent(Component.java:6270)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4861)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4687)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2719)
at java.awt.Component.dispatchEvent(Component.java:4687)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)
at java.awt.EventQueue.access$200(EventQueue.java:103)
at java.awt.EventQueue$3.run(EventQueue.java:694)
at java.awt.EventQueue$3.run(EventQueue.java:692)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:708)
at java.awt.EventQueue$4.run(EventQueue.java:706)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)
Also ADS 14.0.14-5