Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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

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

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

Contributor

Hi binghamc,

 

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

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

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)

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

Contributor

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

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

Explorer

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

Highlighted

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

New Contributor

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