Impala ODBC driver returned an error (SQLExecDirectW)
Hi,
I'm having a problem with ClouderaImpalaODBC64.dll version 2.16.14.1016.
SQLExecDirectW function returns an error when executing the following query:
With variable1 as
(
SELECT orders.order_id, orders.order_date
FROM quest_stage.orders orders
WHERE orders.order_date = (CAST(? AS TIMESTAMP))
)
Select * from variable1
Error details:
[Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000]: ParseException: Syntax error in line 5
It seems to be the problem when you combine WITH and CAST keywords.
Both of the following queries below work:
SELECT orders.order_id, orders.order_date
FROM quest_stage.orders orders
WHERE orders.order_date = (CAST(? AS TIMESTAMP))
----------------------------------------------------------------------------------------------
With variable1 as
(
SELECT orders.order_id, orders.order_date
FROM quest_stage.orders orders
)
Select * from variable1
Could you help me understand what seems to be the problem here and is there any solution to this problem?
