Usage Note 62836: "ERROR...No mapping found for request from user..." occurs when you use SAS/ACCESS® Interface to Impala
 |  |  |  |
When using SAS/ACCESS Interface to Impala, you might receive the following error:
ERROR: CLI open cursor error: [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : No mapping found for request from user 'username@impalaserver.COM' with requested pool ''
The problem occurs when you are required to have a request pool in your Hadoop cluster and you have not specified one.
To circumvent the problem, specify a request pool as shown below:
proc sql ;
connect to impala as dbcon (dsn=data-source-name db=your-database);
execute (set REQUEST_POOl=poolname) by dbcon;
create table demo_imp as select * from connection to dbcon
(select * from table-name);
disconnect from dbcon;
quit;
connect to impala as dbcon (dsn=data-source-name db=your-database);
execute (set REQUEST_POOl=poolname) by dbcon;
create table demo_imp as select * from connection to dbcon
(select * from table-name);
disconnect from dbcon;
quit;
You can also specify a similar setting in a LIBNAME statement using DBCONINIT= option:
libname mylib impala dsn=data-source-name db=your-database dbconinit="set REQUEST_POOl=pool-name";
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Impala | Microsoft® Windows® for x64 | ||
| 64-bit Enabled AIX | ||||
| Linux for x64 | ||||
The problem occurs when you are required to have a request pool in Impala and you have not specified one.
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2018-09-12 13:21:48 |
| Date Created: | 2018-08-29 12:55:52 |