[
https://issues.apache.org/jira/browse/IMPALA-3666?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong resolved IMPALA-3666.
-----------------------------------
Resolution: Invalid
Bug is in a different project.
> ODBC driver fails on EXISTS condition
> -------------------------------------
>
> Key: IMPALA-3666
> URL: https://issues.apache.org/jira/browse/IMPALA-3666
> Project: IMPALA
> Issue Type: Bug
> Components: Clients
> Affects Versions: Impala 2.2
> Reporter: Kieron Briggs
> Assignee: Syed A. Hashmi
> Priority: Minor
> Labels: impala, odbc
> Attachments: SQL.LOG
>
>
> 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:
> {noformat}
> [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
> {noformat}
> 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.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
