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

ODBC driver fails on EXISTS condition

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Invalid
    • Impala 2.2
    • None
    • Clients

    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

            shashmi Syed A. Hashmi
            kbriggs_impala_9a9f Kieron Briggs
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: