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

ODBC driver fails on EXISTS condition

    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

        1. SQL.LOG
          9 kB
          Kieron Briggs

          Activity

            People

            • Assignee:
              shashmi Syed A. Hashmi
              Reporter:
              kbriggs_impala_9a9f Kieron Briggs
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: