Skip to main content

I am creating a view with parameter eg

Set id=1

create or replace view viewname as select * from table where col1=$id

 

and calling this view in streamsets  in jdbc query consumer by defining session variable eg

set I’d=1;

select * from viewname;

 

but streamsets is giving error as session variable does not exist

i guess it is considering two different session for above statement I also tried removing colon from set statement but no luck 

Any suggestions will help 

thank you

 

hello


Reply