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
