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

ParseException while executing CTE query with Bind variable

New Contributor

Does Impala ODBC driver support CTE queries with Bind variables?


I'm using ODBC driver version 2.6.14 and I'm getting ParseException when executing below query:
"with qData as (SELECT orders.order_id FROM quest_stage.orders orders WHERE orders.shipping_address_id = ?) select * from qData"


When I only execute the Select statement with Bind variable it works fine.



Impala ParseException.png

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.