- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
SQLWorkbench: [Simba][ImpalaJDBCDriver](500001) Error getting metadata information
- Labels:
-
Apache Impala
Created on ‎10-11-2017 02:49 PM - edited ‎09-16-2022 05:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I'm not finding much information about this. Which driver version is this occurring with?
Created ‎10-18-2017 12:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Any update on this error. I am also getting this one.
