Connect to impala and set request pool using odbc

[Seb2]

Hi all,

hopefully someone is able to help me. I have established an odbc connection to an impala server and would like to use this connection in sas. Unfortunately I need to set a request pool but it does not work.

I can assign the library with this statement, but can not open a table because I have to set a request pool:

 libname eap odbc noprompt= "dsn=EAP_clientref; " schema=pc_anltcclientref_analysis access = readonly;

So  I tried to add a request pool but now I am receivin an error message:

 libname eap odbc noprompt= "dsn=EAP_clientref; " schema=pc_anltcclientref_analysis dbconinit="set request_pool=root.ACE-S-FRA-EAP-PROD-PC_ANLTCCLIENTREF" access = readonly;

Error Message:

The DBMS connection failed. The DBCONINIT=<command> option failed with this message:
[Cloudera][ImpalaODBC] (360) Syntax error occurred during query execution: [HY000] :
AnalysisException: Syntax error in line 1: set
request_pool=root.ACE-S-FRA-EAP-PROD-PC_ANLTCCLIENTREF ^ Encountered:
. Expected: BLOCK_SIZE, COMMENT, COMPRESSION, DEFAULT, ENCODING, NOT, NULL, PRIMARY, COMMA
CAUSED BY: Exception: Syntax error .
ERROR: Error in the LIBNAME statement.

Thanks in advance for your support.

Kinds regards,

Seb

[SASKiwi]

As a workaround you could try SQL Passthru and use the EXECUTE statement to set the request pool.

[Seb2]

Hi,

thanks for your response. To be honest I have no idea how to set it up. Just had a look to sas help center. If I understand it correctly it is not possible to get a library with your suggested solution but to query directly. My preffered soultions would be a library if it is possible.

Thanks again.

[Seb2 · Accepted solution]

Just found a solution

libname eap32 odbc noprompt= "dsn=EAP32; " schema=pc_anltcclientref_analysis dbconinit="set request_pool='ACE-S-FRA-EAP-PROD-PC_ANLTCCLIENTREF'" access = readonly;