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

COMPUTE STATS should quote all identifiers, including table names

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Impala 1.4.2
    • Fix Version/s: Impala 2.2
    • Component/s: None
    • Environment:
      CDH 5.1.3 Impala 1.4.2

      Description

      COMPUTE STATS cannot work on parquet table names starting with numbers. For example, CREATE TABLE 123_tmp (a string) STORED AS PARQUET; INSERT INTO 123_tmp VALUES ('abc'); COMPUTE STATS 123_tmp returns Query: compute stats 222_tmp
      WARNINGS: AnalysisException: Syntax error in line 1:
      SELECT COUNT FROM denial_logs.222_tmp
      ^
      Encountered: DECIMAL LITERAL
      Expected: ADD, AS, CACHED, CHANGE, COMMENT, CROSS, DROP, FULL, GROUP, HAVING, INNER, JOIN, LEFT, LIKE, LIMIT, LOCATION, OFFSET, ON, ORDER, PARTITION, RENAME, REPLACE, RIGHT, ROW, SELECT, SET, STORED, TBLPROPERTIES, UNCACHED, UNION, USING, VALUES, WHERE, WITH, COMMA, IDENTIFIER

      CAUSED BY: Exception: Syntax error

        Attachments

          Activity

            People

            • Assignee:
              jyu@cloudera.com Juan Yu
              Reporter:
              wangruowen_impala_9d3c Ruowen
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: