Hi,
I get an error quite intermittently.
My code is pretty straight forward with simple libname and proc sql statements something like below:
libname IMP1 impala dsn="XXXXXXX" schema=XXXX; libname IMP2 impala dsn="XXXXXXX" schema=XXYY;
proc sql; create table TBZDY as select a.*,b.* from IMP1.xyz a left join IMP2.zxy b
on a.id=b.id;
This works most days but some odd days, I get the below error
ERROR: CLI open cursor error: [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : Runtime Error: Query ef46070c48782ed0:c7afbf8700000000: 81% Complete (74 out of 91)
quit;
Has anyone encountered a similar error and know why this happens and what can be done to fix it.
... View more