Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-3666

ODBC driver fails on EXISTS condition

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Invalid
    • Affects Version/s: Impala 2.2
    • Fix Version/s: None
    • Component/s: Clients
    • Labels:

      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.

        Attachments

          Activity

            People

            • Assignee:
              shashmi Syed A. Hashmi
              Reporter:
              kbriggs_impala_9a9f Kieron Briggs

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment