Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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

Contributor

Hi binghamc,

 

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

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)

Contributor

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

Explorer

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

New Contributor

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.