Qlik Sense: No mapping found for request from user

Luca8 — Fri, 02 Sep 2022 13:55:56 GMT

Ciao,

I have this problem: a Cloudera Impala Data connection, from Qlik sense server, has been created. I can see schemas and tables, but when Qlik trys to read data, i get following error:

The following error occurred:

[Qlik][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : Runtime Error: No mapping found for request from user 'netgov_prod' with requested pool ''

The error occurred here:

[REPORTER_STATUS_NEW]: SELECT * FROM "PRO_L_DINO_CIC4"."REPORTER_STATUS_NEW"

--------------------

My Cloudera support suggest to add the command before the query (he solved same error in Hive executing this command before the Select...), so I tried to put it in Data Loader:

LIB CONNECT TO 'Cloudera_Impala_test';

SET REQUESTER_POOL='root.dsc_pool';

[REPORTER_STATUS_NEW]:
SELECT *
FROM
"PRO_L_DINO_CIC4"."REPORTER_STATUS_NEW";

but it does not work.

I tried also to insert this command in the Main Section where variables are set, but also in this case i does not work.

The error says:

No mapping found for request from user 'netgov_prod' with requested pool ''

like a pool is not set because is empty.

Is there a field where to put this instruction in Data Connection window creation?

I don't have the grant to access to data connection wizard, so I don't know it.

Did someones faced same problem ?

Thanks

Luca

topic Qlik Sense: No mapping found for request from user in Connectivity & Data Prep

Qlik Sense: No mapping found for request from user