CLI prepare error

[anandmgjsa]

Hello,

I am connecting to Impala. When I am using single variable, there is no error.But if i add another variable a cli error comes. Error is:CLI prepare error: [cloudera][ImpalaODbC] Query analysis error occured during query execution.

I am using the below code:

proc sql;

%conxnimp(eap_v,implink,db,dbmax_test = 30)

create table banners as select * from connection to implink

( select * from( select ccsid,mis_dt from event where mis_dt = '2021-04-28' )b )a;

quit;  

when i run with 'ccsid' in select it runs and gives o/p. But on adding mis_dt it gives the mentioned error.   

[SASKiwi]

Not sure if this helps but looks like you can simplify your query:

proc sql;
%conxnimp(eap_v,implink,db,dbmax_test = 30)
create table banners as select * from connection to implink
(select ccsid, mis_dt from event where mis_dt = '2021-04-28' );
quit;  

Also try selecting another column other than mis_dt in case that is the problem.