SQL Workbench/J - Hive - Create table as Problems

[Amine Mekki]

Hi,

First, I'd like to thank you for your work and futur help.

I am currently trying to use workbench/J with hadoop hive. I'm pretty glad because I've been able to do select queries. Unfortunately trying to run a create table as select terminates with "Method not supported". This kind of request works within HUE.

I've seen this topic and tried to add the workaround, with no results.

So, I would like to know if you think there is something I can do to make it work ?

Thank you for your time and help,

Amine

PS : Here's all the logs I have

2015-04-23 18:52 INFO   =================== Log started =================== 

2015-04-23 18:52 INFO  Settings.initialize() Using configdir: C:\Users\AMekki\.sqlworkbench 

2015-04-23 18:52 DEBUG Settings.initialize() Last modification time of loaded config file: 1429807964978 

2015-04-23 18:52 INFO  ResourceMgr.getResources() Setting default locale to: en 

2015-04-23 18:52 INFO  WbManager.init() Starting SQL Workbench/J, Build 117 (2015-01-04 21:00) 

2015-04-23 18:52 INFO  WbManager.init() Java version=1.7.0_01, java.home=C:\Program Files (x86)\Java\jre7, vendor=Oracle Corporation, name=Java HotSpot(TM) Client VM 

2015-04-23 18:52 INFO  WbManager.init() Operating System=Windows 7, version=6.1, platform=x86 

2015-04-23 18:52 INFO  WbManager.init() Available memory: 989MB 

2015-04-23 18:52 DEBUG MacroManager.init<> Loading default macros took 14ms 

2015-04-23 18:52 DEBUG DbUnitHelper.isDbUnitAvailable() DbUnit not available 

2015-04-23 18:52 INFO  WbManager.runGui() Starting DeadlockMonitor 

2015-04-23 18:52 DEBUG BookmarManager.updateInBackground() Panel 'Statement' was updated in 0ms (0 bookmarks) 

2015-04-23 18:52 DEBUG MacroManager.loadMacros() Loaded macros from file C:\Users\AMekki\.sqlworkbench\WbMacros.xml for clientId:  1 

2015-04-23 18:52 DEBUG BookmarkManager.clearBookmarksForWindow() Removed all bookmarks for window: 1 

2015-04-23 18:52 DEBUG BookmarkManager.updateBookmarks() Parsing bookmarks for 1 tabs took: 7ms 

2015-04-23 18:52 INFO  ConnectionMgr.getConnection() Creating new connection for [{Default group}/Amine Hive] for driver=org.apache.hive.jdbc.HiveDriver and URL=[jdbc:hive2://XXXXXXXX:10000] 

2015-04-23 18:52 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/commons-logging-1.1.3.jar 

2015-04-23 18:52 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hadoop-common-2.5.0-cdh5.3.0.jar 

2015-04-23 18:52 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hive-cli-0.13.1-cdh5.3.0.jar 

2015-04-23 18:52 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hive-exec-0.13.1-cdh5.3.0.jar 

2015-04-23 18:52 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hive-jdbc-0.13.1-cdh5.3.0.jar 

2015-04-23 18:52 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hive-metastore-0.13.1-cdh5.3.0.jar 

2015-04-23 18:52 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hive-service-0.13.1-cdh5.3.0.jar 

2015-04-23 18:52 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/httpclient-4.2.5.jar 

2015-04-23 18:52 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/httpcore-4.2.5.jar 

2015-04-23 18:52 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/libfb303-0.9.0.jar 

2015-04-23 18:52 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/slf4j-api-1.7.5.jar 

2015-04-23 18:52 DEBUG DbMetadata.<init> Schema term: database 

2015-04-23 18:52 DEBUG DbMetadata.<init> Catalog term: instance 

2015-04-23 18:52 INFO  DbMetadata.<init> Using DBID=apache_hive 

2015-04-23 18:52 DEBUG GenericSchemaInfoReader.logSettings() Re-Use statement: false, cache current schema: false, SQL: null 

2015-04-23 18:52 ERROR DbMetadata.<init> Error when retrieving identifier quote character Method not supported

java.sql.SQLException: Method not supported

at org.apache.hive.jdbc.HiveDatabaseMetaData.getIdentifierQuoteString(HiveDatabaseMetaData.java:342)

at workbench.db.DbMetadata.<init>(DbMetadata.java:358)

at workbench.db.WbConnection.setSqlConnection(WbConnection.java:533)

at workbench.db.WbConnection.<init>(WbConnection.java:125)

at workbench.db.ConnectionMgr.connect(ConnectionMgr.java:250)

at workbench.db.ConnectionMgr.getConnection(ConnectionMgr.java:163)

at workbench.gui.components.ConnectionSelector.doConnect(ConnectionSelector.java:233)

at workbench.gui.components.ConnectionSelector$2.run(ConnectionSelector.java:133)

2015-04-23 18:52 INFO  DbMetadata.<init> Using identifier quote character: " 

2015-04-23 18:52 INFO  DbMetadata.<init> Using search string escape character: \ 

2015-04-23 18:52 DEBUG DbMetadata.<init> Using table types returned by the JDBC driver: [TABLE] 

2015-04-23 18:52 WARN  DbMetadata.<init> Driver does not support getMaxTableNameLength() Method not supported

java.sql.SQLException: Method not supported

at org.apache.hive.jdbc.HiveDatabaseMetaData.getMaxTableNameLength(HiveDatabaseMetaData.java:470)

at workbench.db.DbMetadata.<init>(DbMetadata.java:465)

at workbench.db.WbConnection.setSqlConnection(WbConnection.java:533)

at workbench.db.WbConnection.<init>(WbConnection.java:125)

at workbench.db.ConnectionMgr.connect(ConnectionMgr.java:250)

at workbench.db.ConnectionMgr.getConnection(ConnectionMgr.java:163)

at workbench.gui.components.ConnectionSelector.doConnect(ConnectionSelector.java:233)

at workbench.gui.components.ConnectionSelector$2.run(ConnectionSelector.java:133)

2015-04-23 18:52 INFO  DbMetadata.<init> Using catalog separator: . 

2015-04-23 18:52 INFO  ConnectionMgr.getConnection() Connected to: [Apache Hive], Database version: [0.13.1-cdh5.3.2], Driver version: [0.13.1-cdh5.3.0], JDBC Version: [3.0], ID: [Wb1-2] 

2015-04-23 18:52 ERROR DdlCommand.execute() Error executing:

create table sas_tmp.Temp_Amine_Test as

select *

from sas_tmp.test

limit 10

   Method not supported

java.sql.SQLException: Method not supported

at org.apache.hive.jdbc.HiveStatement.setEscapeProcessing(HiveStatement.java:638)

at workbench.sql.commands.DdlCommand.execute(DdlCommand.java:120)

at workbench.sql.StatementRunner.runStatement(StatementRunner.java:543)

at workbench.gui.sql.SqlPanel.displayResult(SqlPanel.java:3247)

at workbench.gui.sql.SqlPanel.runStatement(SqlPanel.java:2101)

at workbench.gui.sql.SqlPanel$14.run(SqlPanel.java:2052)

[Thomas Kellerer]

Hello,


> I've seen this topic <https://groups.google.com/forum/#!topic/sql-workbench/CIdAnVIhQdk> and tried to add the workaround, with no results.

Looking at the log file, Hive now identifies itself differently (previously it only identified itself as Hive, now it is "Apache Hive")
You need to use the DBID "apache_hive", instead of "hive" when applying the change from the above thread:

WbSetConfig workbench.db.apache_hive.ddl.disable.escapeprocessing=false;

You should also set the other defaults I have already added for hive:

WbSetConfig workbench.db.apache_hive.extended.createstmt=false;
WbSetConfig workbench.db.apache_hive.metadata.retrieval.columnnames=false;

Regards
Thomas

[Amine Mekki]

Hi Thomas,

Thank you for your help.

I'm still facing issues despite your recommandations, that I've added to my settings file.

Here's what I get in logs

2015-04-24 01:05 INFO   =================== Log started =================== 

2015-04-24 01:05 INFO  Settings.initialize() Using configdir: C:\Users\AMekki\.sqlworkbench 

2015-04-24 01:05 DEBUG Settings.initialize() Last modification time of loaded config file: 1429830082959 

2015-04-24 01:05 INFO  ResourceMgr.getResources() Setting default locale to: en 

2015-04-24 01:05 INFO  WbManager.init() Starting SQL Workbench/J, Build 117 (2015-01-04 21:00) 

2015-04-24 01:05 INFO  WbManager.init() Java version=1.7.0_01, java.home=C:\Program Files (x86)\Java\jre7, vendor=Oracle Corporation, name=Java HotSpot(TM) Client VM 

2015-04-24 01:05 INFO  WbManager.init() Operating System=Windows 7, version=6.1, platform=x86 

2015-04-24 01:05 INFO  WbManager.init() Available memory: 989MB 

2015-04-24 01:05 DEBUG MacroManager.init<> Loading default macros took 15ms 

2015-04-24 01:05 DEBUG DbUnitHelper.isDbUnitAvailable() DbUnit not available 

2015-04-24 01:05 INFO  WbManager.runGui() Starting DeadlockMonitor 

2015-04-24 01:05 DEBUG BookmarManager.updateInBackground() Panel 'Statement' was updated in 0ms (0 bookmarks) 

2015-04-24 01:05 DEBUG MacroManager.loadMacros() Loaded macros from file C:\Users\AMekki\.sqlworkbench\WbMacros.xml for clientId:  1 

2015-04-24 01:05 DEBUG BookmarkManager.clearBookmarksForWindow() Removed all bookmarks for window: 1 

2015-04-24 01:05 DEBUG BookmarkManager.updateBookmarks() Parsing bookmarks for 1 tabs took: 7ms 

2015-04-24 01:05 INFO  ConnectionMgr.getConnection() Creating new connection for [{Default group}/Hive Amine] for driver=org.apache.hive.jdbc.HiveDriver and URL=[jdbc:hive2://XXXXXXXXXXXXX:10000] 

2015-04-24 01:05 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/commons-logging-1.1.3.jar 

2015-04-24 01:05 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hadoop-common-2.5.0-cdh5.3.0.jar 

2015-04-24 01:05 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hive-cli-0.13.1-cdh5.3.0.jar 

2015-04-24 01:05 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hive-exec-0.13.1-cdh5.3.0.jar 

2015-04-24 01:05 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hive-jdbc-0.13.1-cdh5.3.0.jar 

2015-04-24 01:05 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hive-metastore-0.13.1-cdh5.3.0.jar 

2015-04-24 01:05 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hive-service-0.13.1-cdh5.3.0.jar 

2015-04-24 01:05 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/httpclient-4.2.5.jar 

2015-04-24 01:05 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/httpcore-4.2.5.jar 

2015-04-24 01:05 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/libfb303-0.9.0.jar 

2015-04-24 01:05 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/slf4j-api-1.7.5.jar 

2015-04-24 01:05 DEBUG DbMetadata.<init> Schema term: database 

2015-04-24 01:05 DEBUG DbMetadata.<init> Catalog term: instance 

2015-04-24 01:05 INFO  DbMetadata.<init> Using DBID=apache_hive 

2015-04-24 01:05 DEBUG GenericSchemaInfoReader.logSettings() Re-Use statement: false, cache current schema: false, SQL: null 

2015-04-24 01:05 ERROR DbMetadata.<init> Error when retrieving identifier quote character Method not supported

java.sql.SQLException: Method not supported

at org.apache.hive.jdbc.HiveDatabaseMetaData.getIdentifierQuoteString(HiveDatabaseMetaData.java:342)

at workbench.db.DbMetadata.<init>(DbMetadata.java:358)

at workbench.db.WbConnection.setSqlConnection(WbConnection.java:533)

at workbench.db.WbConnection.<init>(WbConnection.java:125)

at workbench.db.ConnectionMgr.connect(ConnectionMgr.java:250)

at workbench.db.ConnectionMgr.getConnection(ConnectionMgr.java:163)

at workbench.gui.components.ConnectionSelector.doConnect(ConnectionSelector.java:233)

at workbench.gui.components.ConnectionSelector$2.run(ConnectionSelector.java:133)

2015-04-24 01:05 INFO  DbMetadata.<init> Using identifier quote character: " 

2015-04-24 01:05 INFO  DbMetadata.<init> Using search string escape character: \ 

2015-04-24 01:05 DEBUG DbMetadata.<init> Using table types returned by the JDBC driver: [TABLE] 

2015-04-24 01:05 WARN  DbMetadata.<init> Driver does not support getMaxTableNameLength() Method not supported

java.sql.SQLException: Method not supported

at org.apache.hive.jdbc.HiveDatabaseMetaData.getMaxTableNameLength(HiveDatabaseMetaData.java:470)

at workbench.db.DbMetadata.<init>(DbMetadata.java:465)

at workbench.db.WbConnection.setSqlConnection(WbConnection.java:533)

at workbench.db.WbConnection.<init>(WbConnection.java:125)

at workbench.db.ConnectionMgr.connect(ConnectionMgr.java:250)

at workbench.db.ConnectionMgr.getConnection(ConnectionMgr.java:163)

at workbench.gui.components.ConnectionSelector.doConnect(ConnectionSelector.java:233)

at workbench.gui.components.ConnectionSelector$2.run(ConnectionSelector.java:133)

2015-04-24 01:05 INFO  DbMetadata.<init> Using catalog separator: . 

2015-04-24 01:05 INFO  ConnectionMgr.getConnection() Connected to: [Apache Hive], Database version: [0.13.1-cdh5.3.2], Driver version: [0.13.1-cdh5.3.0], JDBC Version: [3.0], ID: [Wb1-2] 

2015-04-24 01:05 ERROR DdlCommand.execute() Error executing:

create table sas_tmp.Test_Amine_v1 as 

select *

from sas_tmp.payment

limit 100

   Method not supported

java.sql.SQLException: Method not supported

at org.apache.hive.jdbc.HiveStatement.setEscapeProcessing(HiveStatement.java:638)

at workbench.sql.commands.DdlCommand.execute(DdlCommand.java:120)

at workbench.sql.StatementRunner.runStatement(StatementRunner.java:543)

at workbench.gui.sql.SqlPanel.displayResult(SqlPanel.java:3247)

at workbench.gui.sql.SqlPanel.runStatement(SqlPanel.java:2101)

at workbench.gui.sql.SqlPanel$14.run(SqlPanel.java:2052)

2015-04-24 01:05 DEBUG ConnectionMgr.disconnect() Trying to physically close the connection with id=Wb1-2 

2015-04-24 01:05 INFO  ConnectionMgr.disconnect() Disconnecting: [Hive Amine], ID=Wb1-2 

2015-04-24 01:05 DEBUG WbConnection.close() Connection Wb1-2 closed. 

2015-04-24 01:05 DEBUG GenericSchemaInfoReader.logSettings() Re-Use statement: false, cache current schema: false, SQL: null 

2015-04-24 01:05 DEBUG BookmarkManager.clearBookmarksForWindow() Removed all bookmarks for window: 1 

2015-04-24 01:05 DEBUG WbManager.closeAllWindows() Closing all open windows 

2015-04-24 01:05 DEBUG Settings.saveSettings() Saving global settings to: C:\Users\AMekki\.sqlworkbench\workbench.settings 

2015-04-24 01:05 INFO  WbManager.doShutdown() Stopping SQL Workbench/J, Build 117 

2015-04-24 01:05 INFO   =================== Log stopped =================== 

[Thomas Kellerer]

> I'm still facing issues despite your recommandations, that I've added to my settings file.

What exactly did you add to the settings file?

Thomas

[Amine Mekki]

Thomas,

I've added the 3 following lines :

WbSetConfig workbench.db.apache_hive.ddl.disable.escapeprocessing=false;

WbSetConfig workbench.db.apache_hive.extended.createstmt=false;

WbSetConfig workbench.db.apache_hive.metadata.retrieval.columnnames=false;

Amine

[Thomas Kellerer]

Those are SQL statements that you run in the SQL panel (and the actual property will then be persisted in the .settings file)

http://www.sql-workbench.net/manual/wb-commands.html#command-setconfig

If you are editing the file directly, then you need to use:

workbench.db.apache_hive.ddl.disable.escapeprocessing=false
workbench.db.apache_hive.extended.createstmt=false
workbench.db.apache_hive.metadata.retrieval.columnnames=false

No "WbSetConfig" and remove the ";" at the end!

Make sure you close SQL Workbench before editing the .settings file.

> --
> You received this message because you are subscribed to the Google Groups "SQL Workbench/J - DBMS independent SQL tool" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to sql-workbenc...@googlegroups.com <mailto:sql-workbenc...@googlegroups.com>.
> For more options, visit https://groups.google.com/d/optout.

[Amine Mekki]

Thomas,

Thank you for your time. I'm now facing a new kind of error that I don't understand :

2015-04-24 09:38 INFO   =================== Log started =================== 

2015-04-24 09:38 INFO  Settings.initialize() Using configdir: C:\Users\AMekki\.sqlworkbench 

2015-04-24 09:38 DEBUG Settings.initialize() Last modification time of loaded config file: 1429861101180 

2015-04-24 09:38 INFO  ResourceMgr.getResources() Setting default locale to: en 

2015-04-24 09:38 INFO  WbManager.init() Starting SQL Workbench/J, Build 117 (2015-01-04 21:00) 

2015-04-24 09:38 INFO  WbManager.init() Java version=1.7.0_01, java.home=C:\Program Files (x86)\Java\jre7, vendor=Oracle Corporation, name=Java HotSpot(TM) Client VM 

2015-04-24 09:38 INFO  WbManager.init() Operating System=Windows 7, version=6.1, platform=x86 

2015-04-24 09:38 INFO  WbManager.init() Available memory: 989MB 

2015-04-24 09:38 DEBUG MacroManager.init<> Loading default macros took 15ms 

2015-04-24 09:38 DEBUG DbUnitHelper.isDbUnitAvailable() DbUnit not available 

2015-04-24 09:38 INFO  WbManager.runGui() Starting DeadlockMonitor 

2015-04-24 09:38 DEBUG BookmarManager.updateInBackground() Panel 'Statement' was updated in 0ms (0 bookmarks) 

2015-04-24 09:38 DEBUG MacroManager.loadMacros() Loaded macros from file C:\Users\AMekki\.sqlworkbench\WbMacros.xml for clientId:  1 

2015-04-24 09:38 DEBUG BookmarkManager.clearBookmarksForWindow() Removed all bookmarks for window: 1 

2015-04-24 09:38 DEBUG BookmarkManager.updateBookmarks() Parsing bookmarks for 1 tabs took: 7ms 

2015-04-24 09:38 INFO  ConnectionMgr.getConnection() Creating new connection for [{Default group}/Hive Amine] for driver=org.apache.hive.jdbc.HiveDriver and URL=[jdbc:hive2://XXXXXXXXX:10000] 

2015-04-24 09:38 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/commons-logging-1.1.3.jar 

2015-04-24 09:38 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hadoop-common-2.5.0-cdh5.3.0.jar 

2015-04-24 09:38 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hive-cli-0.13.1-cdh5.3.0.jar 

2015-04-24 09:38 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hive-exec-0.13.1-cdh5.3.0.jar 

2015-04-24 09:38 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hive-jdbc-0.13.1-cdh5.3.0.jar 

2015-04-24 09:38 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hive-metastore-0.13.1-cdh5.3.0.jar 

2015-04-24 09:38 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/hive-service-0.13.1-cdh5.3.0.jar 

2015-04-24 09:38 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/httpclient-4.2.5.jar 

2015-04-24 09:38 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/httpcore-4.2.5.jar 

2015-04-24 09:38 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/libfb303-0.9.0.jar 

2015-04-24 09:38 INFO  DbDriver.loadDriverClass() Adding ClassLoader URL=file:/C:/Users/AMekki/Desktop/Hive_Jars/slf4j-api-1.7.5.jar 

2015-04-24 09:38 DEBUG DbMetadata.<init> Schema term: database 

2015-04-24 09:38 DEBUG DbMetadata.<init> Catalog term: instance 

2015-04-24 09:38 INFO  DbMetadata.<init> Using DBID=apache_hive 

2015-04-24 09:38 DEBUG GenericSchemaInfoReader.logSettings() Re-Use statement: false, cache current schema: false, SQL: null 

2015-04-24 09:38 ERROR DbMetadata.<init> Error when retrieving identifier quote character Method not supported

java.sql.SQLException: Method not supported

at org.apache.hive.jdbc.HiveDatabaseMetaData.getIdentifierQuoteString(HiveDatabaseMetaData.java:342)

at workbench.db.DbMetadata.<init>(DbMetadata.java:358)

at workbench.db.WbConnection.setSqlConnection(WbConnection.java:533)

at workbench.db.WbConnection.<init>(WbConnection.java:125)

at workbench.db.ConnectionMgr.connect(ConnectionMgr.java:250)

at workbench.db.ConnectionMgr.getConnection(ConnectionMgr.java:163)

at workbench.gui.components.ConnectionSelector.doConnect(ConnectionSelector.java:233)

at workbench.gui.components.ConnectionSelector$2.run(ConnectionSelector.java:133)

2015-04-24 09:38 INFO  DbMetadata.<init> Using identifier quote character: " 

2015-04-24 09:38 INFO  DbMetadata.<init> Using search string escape character: \ 

2015-04-24 09:38 DEBUG DbMetadata.<init> Using table types returned by the JDBC driver: [TABLE] 

2015-04-24 09:38 WARN  DbMetadata.<init> Driver does not support getMaxTableNameLength() Method not supported

java.sql.SQLException: Method not supported

at org.apache.hive.jdbc.HiveDatabaseMetaData.getMaxTableNameLength(HiveDatabaseMetaData.java:470)

at workbench.db.DbMetadata.<init>(DbMetadata.java:465)

at workbench.db.WbConnection.setSqlConnection(WbConnection.java:533)

at workbench.db.WbConnection.<init>(WbConnection.java:125)

at workbench.db.ConnectionMgr.connect(ConnectionMgr.java:250)

at workbench.db.ConnectionMgr.getConnection(ConnectionMgr.java:163)

at workbench.gui.components.ConnectionSelector.doConnect(ConnectionSelector.java:233)

at workbench.gui.components.ConnectionSelector$2.run(ConnectionSelector.java:133)

2015-04-24 09:38 INFO  DbMetadata.<init> Using catalog separator: . 

2015-04-24 09:38 INFO  ConnectionMgr.getConnection() Connected to: [Apache Hive], Database version: [0.13.1-cdh5.3.2], Driver version: [0.13.1-cdh5.3.0], JDBC Version: [3.0], ID: [Wb1-2] 

2015-04-24 09:38 ERROR DdlCommand.execute() Error executing:

create table sas_tmp.Test_Amine_v1 as 

select *

from sas_tmp.payment

limit 100

   Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask [SQL State=08S01, DB Errorcode=1] 

java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask

at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:277)

at workbench.sql.commands.DdlCommand.execute(DdlCommand.java:152)

at workbench.sql.StatementRunner.runStatement(StatementRunner.java:543)

at workbench.gui.sql.SqlPanel.displayResult(SqlPanel.java:3247)

at workbench.gui.sql.SqlPanel.runStatement(SqlPanel.java:2101)

at workbench.gui.sql.SqlPanel$14.run(SqlPanel.java:2052)

2015-04-24 09:38 DEBUG ConnectionMgr.disconnect() Trying to physically close the connection with id=Wb1-2 

2015-04-24 09:38 INFO  ConnectionMgr.disconnect() Disconnecting: [Hive Amine], ID=Wb1-2 

2015-04-24 09:38 DEBUG WbConnection.close() Connection Wb1-2 closed. 

2015-04-24 09:38 DEBUG GenericSchemaInfoReader.logSettings() Re-Use statement: false, cache current schema: false, SQL: null 

2015-04-24 09:38 DEBUG BookmarkManager.clearBookmarksForWindow() Removed all bookmarks for window: 1 

2015-04-24 09:38 DEBUG WbManager.closeAllWindows() Closing all open windows 

2015-04-24 09:38 DEBUG Settings.saveSettings() Saving global settings to: C:\Users\AMekki\.sqlworkbench\workbench.settings 

2015-04-24 09:38 INFO  WbManager.doShutdown() Stopping SQL Workbench/J, Build 117 

> To unsubscribe from this group and stop receiving emails from it, send an email to sql-workbenc...@googlegroups.com <mailto:sql-workbench+unsub...@googlegroups.com>.

[Amine Mekki]

Hi Thomas.

I've found the problem. It was a credential issue since the user I was using haven't enough permission.

Thank you again for your precious help.

Amine

Le jeudi 23 avril 2015 19:04:37 UTC+2, Amine Mekki a écrit :