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

Not informative syntax error in UPDATE statement

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Won't Fix
    • Impala 2.6.0
    • None
    • Frontend

    Description

      A weird error is thrown when anything other than '=' is used in the SET portion of an UPDATE statement. Example:

      impala-shell> update t1 set b != 1 where a = 1;
Query: update t1 set b != 1 where a = 1;
ERROR: AnalysisException: Syntax error in line 1:
update t1 set b != 1 where a = 1
                         ^
Encountered: Unknown last token with id: 200
Expected

CAUSED BY: Exception: Syntax error

      Attachments

        Activity

          People

            Unassigned Unassigned
            dtsirogiannis Dimitris Tsirogiannis
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: