Member since
02-17-2022
2
Posts
0
Kudos Received
0
Solutions
02-18-2022
11:43 AM
Using the Impala ODBC driver (2.6.14), I'm getting ParseException while executing a Select statement with Bind variable without the database name qualifier before table name. Details: In ODBC driver configuration I remove the database name field and leave it blank I execute Use database command to set the database context (i.e. "use testDb") When I execute below Select statement with Bind variable I get ParseException "select * from address where address_id = ?" Exception: In the same scenario, If I execute the same Select statement without the Bind variable (e.g. address_id = 3) it works fine. The Select statement with Bind variable also works fine if I add database name qualifier e.g.: "select * from testDb.address where address_id = ?" Is this a known issue for Impala ODBC driver?
... View more
Labels:
- Labels:
-
Apache Impala
02-17-2022
11:46 AM
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. Exception:
... View more
Labels:
- Labels:
-
Apache Impala