[IMPALA-3666] ODBC driver fails on EXISTS condition

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Invalid
• Affects Version/s: Impala 2.2
• Component/s: Clients
• Labels: impala odbc
• Target Version: Impala 2.10.0
• Assignee: Syed A. Hashmi
• Reporter: Kieron Briggs
• Created: 03/Jun/16 06:30
• Updated: 23/Aug/17 18:43
• Resolved: 23/Aug/17 18:43

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.