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

Date Posted: 2018-06-08
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.