topic Qlik Sense Impala data connection error in Connectivity & Data Prep

Qlik Sense Impala data connection error

t_nikhilareddy — Wed, 05 Jan 2022 19:18:36 GMT

Hi,

I'm trying to create a Cloudera Impala connection using the built in connector in Qlik sense (enterprise version). I'm able to successfully create the connection but it's throwing below error while trying to fetch data from the connection created. It's working in QlikView when I tried to create the same connection. Not sure what's wrong with built-in Impala driver provided in Qlik Sense. Can someone please suggest what can be done if you've faced this issue before?

ERROR [HY000] [Qlik][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : No mapping found for request from user 'xxxxx@yyyyy.COM' with requested pool ''

Qlik Sense version used v14.20.13

All the connection details including Username and pwd and Requested pool name are right as it's working in qlikview.

Thanks in advance!

Re: Qlik Sense Impala data connection error

Ayaka_Hanazono — Mon, 17 Jan 2022 01:23:36 GMT

Hi @t_nikhilareddy
If the same credentials and configuration work with QlikView, the issue could be related to Qlik Connector.

Would it be possible to set up a connection using a native impala driver?
https://www.cloudera.com/downloads/connectors/impala/odbc/2-6-11.html

I hope it helps.

Re: Qlik Sense Impala data connection error

t_nikhilareddy — Tue, 18 Jan 2022 14:53:10 GMT

Hi,

We're trying to install the Qlik ODBC connector on our server and try the connections. Also we can cancel today's call and reschedule later (if needed) if we face any issues with ODBC connector.

Meanwhile, can you please find out why the direct Qlik Connector is not working?

I will keep you posted on the ODBC connection once after trying. Please keep this ticket open until then.

Thanks,

Nikhila

Re: Qlik Sense Impala data connection error

EromiyaManickam_UOB — Mon, 20 May 2024 10:02:24 GMT

Can you please advise whether issue is resolved, Can you please share the solution steps