[jira] [Created] (KYLIN-1090) Cannot query a column whose name is one of the following: year, month, day, hour, minute, second

[Francesco Palmiotto (JIRA)]

Francesco Palmiotto created KYLIN-1090:
------------------------------------------

             Summary: Cannot query a column whose name is one of the following: 
year, month, day, hour, minute, second
                 Key: KYLIN-1090
                 URL: https://issues.apache.org/jira/browse/KYLIN-1090
             Project: Kylin
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: v1.1
            Reporter: Francesco Palmiotto
            Assignee: liyang


Suppose we have a query like:

"select f.year, avg(f.my_measure)
from fact_table f
group by f.year"

This will fail and throw the following error:

Encountered ". year" at line 1, column 9. Was expecting one of: "FROM" ... "," 
... "AS" ... <IDENTIFIER> ... <QUOTED_IDENTIFIER> ... <BACK_QUOTED_IDENTIFIER> 
... <BRACKET_QUOTED_IDENTIFIER> ... <UNICODE_QUOTED_IDENTIFIER> ... "." ... 
"NOT" ... "IN" ... "BETWEEN" ... "LIKE" ... "SIMILAR" ... "=" ... ">" ... "<" 
... "<=" ... ">=" ... "<>" ... "+" ... "-" ... "*" ... "/" ... "||" ... "AND" 
... "OR" ... "IS" ... "MEMBER" ... "SUBMULTISET" ... "MULTISET" ... "[" ... "." 
<IDENTIFIER> ... "." <QUOTED_IDENTIFIER> ... "." <BACK_QUOTED_IDENTIFIER> ... 
"." <BRACKET_QUOTED_IDENTIFIER> ... "." <UNICODE_QUOTED_IDENTIFIER> ... "." "*" 
... "(" ...


I think this is due to the fact that year, month, day, hour, minute and second 
are all reserved keywords in ANSI SQL.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)