Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Invalid
-
Impala 2.2
-
None
Description
Using the latest Cloudera ODBC driver for Impala (2.05.33.1004) on Windows, the query SELECT item_name, retail_price FROM item WHERE EXISTS (SELECT item_id FROM item) fails to execute, with the error:
[Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AnalysisException: Syntax error in line 1: ...ge`.`item` `item` WHERE ^ Encountered: EOF Expected: CASE, CAST, EXISTS, FALSE, IF, INTERVAL, NOT, NULL, TRUE, IDENTIFIER CAUSED BY: Exception: Syntax error
The same query executes correctly in impala-shell. It seems to be the EXISTS condition causing the failure, as other conditions work correctly. Attached is the driver manage trace log showing the query submitted and the error returned.