Support Questions
Find answers, ask questions, and share your expertise

SSRS Parameters to Impala does not work with CTE

New Contributor

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

 

Any help?