Products | Versions |
---|---|
Spotfire Connector for Cloudera Impala | All Versions |
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.