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
... View more