topic Re: Impala ODBC - Authorization Error while reading table in Connectivity & Data Prep

Impala ODBC - Authorization Error while reading table

Fri, 02 Apr 2021 07:58:21 GMT

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.

Re: Impala ODBC - Authorization Error while reading table

Anonymous — Fri, 13 Apr 2018 07:06:29 GMT

Hi Prajakta Salgar,

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

Re: Impala ODBC - Authorization Error while reading table

EromiyaManickam_UOB — Tue, 29 Aug 2023 02:40:44 GMT

is this sorted, What was issue !

Re: Impala ODBC - Authorization Error while reading table

EromiyaManickam_UOB — Tue, 29 Aug 2023 04:09:43 GMT

in my case, I found the solution you need to update settings.ini file

Engine Settings.ini Files. This is located under %ProgramData%\Qlik\Sense\Engine folder. Explicitly put in these 4 lines of setting for the SSO setup. Restart the Engine and Dispatcher services after setting this. If there are 2 or more engines nodes, both engine nodes has to be setup if they are serving the same purpose.