topic Connection SAS EG to impala in SAS Programming

Connection SAS EG to impala

anandmgjsa — Sat, 01 May 2021 11:20:35 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'

)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: Connection SAS EG to impala

Patrick — Sun, 02 May 2021 02:08:16 GMT

There is definitely an unnecessary select * in your code (code should still be valid though).

What happens if you execute below with one select * removed and with a semicolon after the macro call (just in case the macro call doesn't create a connect statement that ends with a semicolon).

options sastrace=',,,d' sastraceloc=saslog nostsuffix;
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;