topic Re: Connect to impala and set request pool using odbc in SAS Programming

Connect to impala and set request pool using odbc

Seb2 — Fri, 03 Sep 2021 12:16:10 GMT

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

Re: Connect to impala and set request pool using odbc

SASKiwi — Fri, 03 Sep 2021 23:17:58 GMT

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

Re: Connect to impala and set request pool using odbc

Seb2 — Tue, 07 Sep 2021 10:57:32 GMT

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.

Re: Connect to impala and set request pool using odbc

Seb2 — Wed, 08 Sep 2021 13:51:33 GMT

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;