Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

Failed to retrieve list of data tables while making use of Impala connection.

Rich Talbot
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

Failed to retrieve list of data tables while making use of Impala connection.


Solution:

Description:
While making use of Cloudera connector with Tibco Spotfire Analyst, even though the authentication is done successfully the Cloudera connector is not able to access the desired data tables.

Symptoms:
Error message from Tibco Spotfire Analyst logs. 

2015-01-09 12:13:18,408 [16] INFO  Spotfire.Dxp.Data.Adapters.Impala.ImpalaAdapterConnection [(null)] - Failed to retrieve list of tables.
System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AuthorizationException: User 'manoj' does not have privileges to access: default.*
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderFromSQLMethod(Object[] methodArguments, SQL_API method)
   at System.Data.Odbc.OdbcMetaDataFactory.GetTablesCollection(String[] restrictions, OdbcConnection connection, Boolean isTables)
   at System.Data.Odbc.OdbcMetaDataFactory.PrepareCollection(String collectionName, String[] restrictions, DbConnection connection)
   at System.Data.ProviderBase.DbMetaDataFactory.GetSchema(DbConnection connection, String collectionName, String[] restrictions)
   at System.Data.ProviderBase.DbConnectionInternal.GetSchema(DbConnectionFactory factory, DbConnectionPoolGroup poolGroup, DbConnection outerConnection, String collectionName, String[] restrictions)
   at System.Data.Odbc.OdbcConnection.GetSchema(String collectionName, String[] restrictionValues)
   at Spotfire.Dxp.Data.Adapters.Impala.ImpalaAdapterConnection.ListTablesCoreImpl(ICollection`1 resultTables)

Cause:
The Cloudera database user used in the connection does not have access to the default schema. Grant read access permission to the default schema for the Cloudera database user used in the connection.

Related articles