CLI prepare error

anandmgjsa — Sat, 01 May 2021 12:34:29 GMT

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.

Re: CLI prepare error

SASKiwi — Sun, 02 May 2021 01:57:04 GMT

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.

topic CLI prepare error in SAS Enterprise Guide

CLI prepare error

Re: CLI prepare error