Alan Jackoway created IMPALA-6848:
-------------------------------------
Summary: 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.12.0
Reporter: Alan Jackoway
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)
