We are facing the CLI Error intermittently, when parsing thru Impala(Both Parquet/Standard) and Hive tables using SAS ODBC Connection.
ERROR: CLI cursor fetch error: [Cloudera][ImpalaODBC] (120) Error while retrieving data from in
Impala: [HY000] : RPC Error: SSL_read: Resource temporarily unavailable
ERROR: CLI cursor fetch error: [Cloudera][Hardy] (35) Error from server: error code: '0' error
message: 'Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT,
Any help is higly appriciated!!
code is pretty straight farward with simple libname and proc sql statements :
libname impala odbc dsn="XXXXXXX" user=XXXXXXX password='XXXXX' schema=XXXX;
libname tgtlib "XXXXX";
create table tgtlib.xyz as
select * from impala.xyz;
I have active ticket from kerberos.
proc sql (executing from PC SAS) runs for about 15-20min and then it fails with above error saying resource unavaialble.
fyi, this is a huge table with 4k+ columns and 2 million+ records.
Tried with filtering data to different chunks and it works fine, but issue is I get duplicate records in each indivudual chuck i.e. count mismtach with source.
Can you execute your query directly in Impala/Hive?
it may need detailed analysis, becuase
1. If your answer is yes for my above question, the similar issue "Resource temporarily unavailable error message from Impala shell " has already been discussed in this link
2. if your answer is no then it might be an issue with ODBC (or) your network capacity issue for the table with huge size.