Support Questions

Find answers, ask questions, and share your expertise

SQLWorkbench: [Simba][ImpalaJDBCDriver](500001) Error getting metadata information

avatar
Explorer

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.


Impala JDBC Error.jpg
5 REPLIES 5

avatar
Rising Star

Hi binghamc,

 

Can you enable debug logging (page 22 of this doc, select level 5) for more insight into the error? 

avatar
Explorer

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)

avatar
Rising Star

I'm not finding much information about this. Which driver version is this occurring with?

avatar
Explorer

I have tried the last 3 versions listed in the downloads.  Seems to be with all of them.

avatar
New Contributor

Any update on this error. I am also getting this one.