Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

Not applicable

Impala ODBC - Authorization Error while reading table

I have created Impala ODBC connection, and I am able test it successfully. But while executing query using that ODBC connection, Qlikview is throwing below error -

SQL##f - SqlState: S1000, ErrorCode: 110, ErrorMsg: [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AuthorizationException: User 'xyz' does not have privileges to execute 'SELECT' on: default.abcd

but strangely, I am able to query 'abcd' table through Hive. I have read privileges on this table.

Not sure why it's failing in Qlikiew and my table name is prefixed by 'default' word.

Truly appreciate if you could help me resolving this. Thanks a ton in advance.

1 Reply
kumarramasamy
New Contributor

Re: Impala ODBC - Authorization Error while reading table

Hi Prajakta Salgar,

   I am also get exactly the same error. If it is get resolved in your end share us.