Created on 10-11-2017 02:49 PM - edited 09-16-2022 05:23 AM
When selecting a table in SQL Workbench Database explorer or when sleetcing "Push Select into new tab." from the Database Explorer we get the error message:
[Simba][ImpalaJDBCDriver](500001) Error getting metadata information
Test connection, schema table listing etc all works fine. I can manually select in a new tab and it fetches data without issue, it is just operations on the Database Exploere tab that throws an error.
In fact even on the Database Explorer tab, you can refresh the data tab of a table and it fetches the data.
Created 10-17-2017 12:58 PM
Hi binghamc,
Can you enable debug logging (page 22 of this doc, select level 5) for more insight into the error?
Created 10-18-2017 07:55 AM
Sure...I have and this is what appears:
Oct 18 08:49:46.163 ERROR 32 com.cloudera.impala.exceptions.ExceptionConverter.toSQLException: [Simba][ImpalaJDBCDriver](500001) Error getting metadata information: Metadata Initialization Error.
java.sql.SQLException: [Simba][ImpalaJDBCDriver](500001) Error getting metadata information: Metadata Initialization Error.
at com.cloudera.impala.hivecommon.dataengine.metadata.HiveJDBCColumnsMetadataSource.initializeColumn(HiveJDBCColumnsMetadataSource.java:417)
at com.cloudera.impala.hivecommon.dataengine.metadata.HiveJDBCColumnsMetadataSource.<init>(HiveJDBCColumnsMetadataSource.java:130)
at com.cloudera.impala.hivecommon.dataengine.HiveJDBCDataEngine.makeNewMetadataSource(HiveJDBCDataEngine.java:445)
at com.cloudera.impala.dsi.dataengine.impl.DSIDataEngine.makeNewMetadataResult(DSIDataEngine.java:198)
at com.cloudera.impala.jdbc.jdbc4.S4DatabaseMetaData.createMetaDataResult(S4DatabaseMetaData.java:257)
at com.cloudera.impala.jdbc.common.SDatabaseMetaData.getColumns(SDatabaseMetaData.java:929)
at workbench.db.JdbcTableDefinitionReader.getColumns(JdbcTableDefinitionReader.java:265)
at workbench.db.JdbcTableDefinitionReader.getTableColumns(JdbcTableDefinitionReader.java:135)
at workbench.db.JdbcTableDefinitionReader.getTableDefinition(JdbcTableDefinitionReader.java:344)
at workbench.db.DbMetadata.getObjectDetails(DbMetadata.java:2444)
at workbench.gui.dbobjects.TableDefinitionPanel.retrieveTableDefinition(TableDefinitionPanel.java:379)
at workbench.gui.dbobjects.TableDefinitionPanel.retrieve(TableDefinitionPanel.java:349)
at workbench.gui.dbobjects.TableListPanel.retrieveTableDefinition(TableListPanel.java:1900)
at workbench.gui.dbobjects.TableListPanel.retrieveSelectedPanel(TableListPanel.java:2002)
at workbench.gui.dbobjects.TableListPanel.retrieveCurrentPanel(TableListPanel.java:1979)
Caused by: com.cloudera.impala.support.exceptions.GeneralException: [Simba][ImpalaJDBCDriver](500001) Error getting metadata information: Metadata Initialization Error.
... 15 more
Caused by: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at java.util.ArrayList.rangeCheck(Unknown Source)
at java.util.ArrayList.get(Unknown Source)
at com.cloudera.impala.hivecommon.dataengine.metadata.HiveJDBCColumnsMetadataSource.initializeColumn(HiveJDBCColumnsMetadataSource.java:411)
at com.cloudera.impala.hivecommon.dataengine.metadata.HiveJDBCColumnsMetadataSource.<init>(HiveJDBCColumnsMetadataSource.java:130)
at com.cloudera.impala.hivecommon.dataengine.HiveJDBCDataEngine.makeNewMetadataSource(HiveJDBCDataEngine.java:445)
at com.cloudera.impala.dsi.dataengine.impl.DSIDataEngine.makeNewMetadataResult(DSIDataEngine.java:198)
at com.cloudera.impala.jdbc.jdbc4.S4DatabaseMetaData.createMetaDataResult(S4DatabaseMetaData.java:257)
at com.cloudera.impala.jdbc.common.SDatabaseMetaData.getColumns(SDatabaseMetaData.java:929)
at workbench.db.JdbcTableDefinitionReader.getColumns(JdbcTableDefinitionReader.java:265)
at workbench.db.JdbcTableDefinitionReader.getTableColumns(JdbcTableDefinitionReader.java:135)
at workbench.db.JdbcTableDefinitionReader.getTableDefinition(JdbcTableDefinitionReader.java:344)
at workbench.db.DbMetadata.getObjectDetails(DbMetadata.java:2444)
at workbench.gui.dbobjects.TableDefinitionPanel.retrieveTableDefinition(TableDefinitionPanel.java:379)
at workbench.gui.dbobjects.TableDefinitionPanel.retrieve(TableDefinitionPanel.java:349)
at workbench.gui.dbobjects.TableListPanel.retrieveTableDefinition(TableListPanel.java:1900)
at workbench.gui.dbobjects.TableListPanel.retrieveSelectedPanel(TableListPanel.java:2002)
at workbench.gui.dbobjects.TableListPanel.retrieveCurrentPanel(TableListPanel.java:1979)
at workbench.gui.dbobjects.TableListPanel$3.run(TableListPanel.java:1932)
Created 10-18-2017 11:51 AM
I'm not finding much information about this. Which driver version is this occurring with?
Created 10-18-2017 12:16 PM
I have tried the last 3 versions listed in the downloads. Seems to be with all of them.
Created 01-09-2018 03:44 AM
Any update on this error. I am also getting this one.