i'm trying to query impala from ssrs, using odbc.
when i use the below query it works.
select a,b from c where b=?
But this doesnt work.
with cte as (select a,b from c where b=?) select * from cte