[
https://issues.apache.org/jira/browse/IMPALA-6848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Fredy Wijaya resolved IMPALA-6848.
----------------------------------
Resolution: Duplicate
> Field Names Parsed as Decimal
> -----------------------------
>
> Key: IMPALA-6848
> URL: https://issues.apache.org/jira/browse/IMPALA-6848
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Affects Versions: Impala 2.9.0
> Reporter: Alan Jackoway
> Priority: Major
> Labels: parser
>
> If you run this query:
> {code:sql}
> with x as (select date_sub(now(),interval 6 months) 6_months_ago)
> select x.6_months_ago from x;
> {code}
> You get an error:
> {code}
> ERROR: AnalysisException: Syntax error in line 2:
> select x.6_months_ago
> ^
> Encountered: DECIMAL LITERAL
> Expected: ADD, ALTER, AND, ARRAY, AS, ASC, BETWEEN, BIGINT, BINARY,
> BLOCK_SIZE, BOOLEAN, CACHED, CASCADE, CHANGE, CHAR, COMMENT, COMPRESSION,
> CROSS, DATE, DATETIME, DECIMAL, DEFAULT, DESC, DIV, REAL, DROP, ELSE,
> ENCODING, END, FLOAT, FOLLOWING, FROM, FULL, GROUP, IGNORE, HAVING, ILIKE,
> IN, INNER, INTEGER, IREGEXP, IS, JOIN, LEFT, LIKE, LIMIT, LOCATION, MAP, NOT,
> NULL, NULLS, OFFSET, ON, OR, ORDER, PARTITION, PARTITIONED, PRECEDING,
> PRIMARY, PURGE, RANGE, RECOVER, REGEXP, RENAME, REPLACE, RESTRICT, RIGHT,
> RLIKE, ROW, ROWS, SELECT, SET, SMALLINT, SORT, STORED, STRAIGHT_JOIN, STRING,
> STRUCT, TABLESAMPLE, TBLPROPERTIES, THEN, TIMESTAMP, TINYINT, TO, UNCACHED,
> UNION, USING, VALUES, VARCHAR, WHEN, WHERE, WITH, COMMA, IDENTIFIER
> {code}
> It's parsing fields that start with a number as a decimal.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
