You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by "Bin.Li" <bi...@qq.com> on 2016/03/23 04:47:23 UTC
Encountered "day" at line 1, column 8. Was expecting one of: "UNION" ... "INTERSECT" ..
hello,
Day is a partition field(string, eg: 20160322), and its a dimision in my cube, but when I query 'group by day', I got the following error.
What the problem is ??
ERROR MSG:
Encountered "day" at line 1, column 8. Was expecting one of: "UNION" ... "INTERSECT" ... "EXCEPT" ... "ORDER" ... "LIMIT" ... "OFFSET" ... "FETCH" ... "STREAM" ... "DISTINCT" ... "ALL" ... "*" ... "+" ... "-" ... <UNSIGNED_INTEGER_LITERAL> ... <DECIMAL_NUMERIC_LITERAL> ... <APPROX_NUMERIC_LITERAL> ... <BINARY_STRING_LITERAL> ... <PREFIXED_STRING_LITERAL> ... <QUOTED_STRING> ... <UNICODE_STRING_LITERAL> ... "TRUE" ... "FALSE" ... "UNKNOWN" ... "NULL" ... <LBRACE_D> ... <LBRACE_T> ... <LBRACE_TS> ... "DATE" ... "TIME" ... "TIMESTAMP" ... "INTERVAL" ... "?" ... "CAST" ... "EXTRACT" ... "POSITION" ... "CONVERT" ... "TRANSLATE" ... "OVERLAY" ... "FLOOR" ... "CEIL" ... "CEILING" ... "SUBSTRING" ... "TRIM" ... <LBRACE_FN> ... "MULTISET" ... "ARRAY" ... "SPECIFIC" ... <IDENTIFIER> ... <QUOTED_IDENTIFIER> ... <BACK_QUOTED_IDENTIFIER> ... <BRACKET_QUOTED_IDENTIFIER> ... <UNICODE_QUOTED_IDENTIFIER> ... "ABS" ... "AVG" ... "CARDINALITY" ... "CHAR_LENGTH" ... "CHARACTER_LENGTH" ... "COALESCE" ... "COLLECT" ... "COVAR_POP" ... "COVAR_SAMP" ... "CUME_DIST" ... "COUNT" ... "CURRENT_DATE" ... "CURRENT_TIME" ... "CURRENT_TIMESTAMP" ... "DENSE_RANK" ... "ELEMENT" ... "EXP" ... "FIRST_VALUE" ... "FUSION" ... "GROUPING" ... "LAST_VALUE" ... "LN" ... "LOCALTIME" ... "LOCALTIMESTAMP" ... "LOWER" ... "MAX" ... "MIN" ... "MOD" ... "NULLIF" ... "OCTET_LENGTH" ... "PERCENT_RANK" ... "POWER" ... "RANK" ... "REGR_SXX" ... "REGR_SYY" ... "ROW_NUMBER" ... "SQRT" ... "STDDEV_POP" ... "STDDEV_SAMP" ... "SUM" ... "UPPER" ... "VAR_POP" ... "VAR_SAMP" ... "CURRENT_CATALOG" ... "CURRENT_DEFAULT_TRANSFORM_GROUP" ... "CURRENT_PATH" ... "CURRENT_ROLE" ... "CURRENT_SCHEMA" ... "CURRENT_USER" ... "SESSION_USER" ... "SYSTEM_USER" ... "USER" ... "NEW" ... "CASE" ... "NEXT" ... "CURRENT" ... "CURSOR" ... "ROW" ... "NOT" ... "EXISTS" ... "(" ..
Many tks!!
bin.li
回复： Encountered "day" at line 1, column 8. Was expecting one of:"UNION" ... "INTERSECT" ..
Posted by "Bin.Li" <bi...@qq.com>.
hello,
OK It works!!! Many tks!!!
group by "DAY"
More reserved words see:
http://calcite.apache.org/docs/reference.html#keywords
bin.li
------------------ 原始邮件 ------------------
发件人: "yu feng";<ol...@gmail.com>;
发送时间: 2016年3月23日(星期三) 中午12:45
收件人: "user"<us...@kylin.apache.org>;
主题: Re: Encountered "day" at line 1, column 8. Was expecting one of:"UNION" ... "INTERSECT" ..
Because day is a keyword in calcite(such as extract(day from col)),so you need use double quote on both sides of day, so in kylin all column is capital word, you need write this column like "DAY", year、month are the same format.
hope it works for you.
2016-03-23 11:47 GMT+08:00 Bin.Li <bi...@qq.com>:
hello,
Day is a partition field(string, eg: 20160322), and its a dimision in my cube, but when I query 'group by day', I got the following error.
What the problem is ??
ERROR MSG:
Encountered "day" at line 1, column 8. Was expecting one of: "UNION" ... "INTERSECT" ... "EXCEPT" ... "ORDER" ... "LIMIT" ... "OFFSET" ... "FETCH" ... "STREAM" ... "DISTINCT" ... "ALL" ... "*" ... "+" ... "-" ... <UNSIGNED_INTEGER_LITERAL> ... <DECIMAL_NUMERIC_LITERAL> ... <APPROX_NUMERIC_LITERAL> ... <BINARY_STRING_LITERAL> ... <PREFIXED_STRING_LITERAL> ... <QUOTED_STRING> ... <UNICODE_STRING_LITERAL> ... "TRUE" ... "FALSE" ... "UNKNOWN" ... "NULL" ... <LBRACE_D> ... <LBRACE_T> ... <LBRACE_TS> ... "DATE" ... "TIME" ... "TIMESTAMP" ... "INTERVAL" ... "?" ... "CAST" ... "EXTRACT" ... "POSITION" ... "CONVERT" ... "TRANSLATE" ... "OVERLAY" ... "FLOOR" ... "CEIL" ... "CEILING" ... "SUBSTRING" ... "TRIM" ... <LBRACE_FN> ... "MULTISET" ... "ARRAY" ... "SPECIFIC" ... <IDENTIFIER> ... <QUOTED_IDENTIFIER> ... <BACK_QUOTED_IDENTIFIER> ... <BRACKET_QUOTED_IDENTIFIER> ... <UNICODE_QUOTED_IDENTIFIER> ... "ABS" ... "AVG" ... "CARDINALITY" ... "CHAR_LENGTH" ... "CHARACTER_LENGTH" ... "COALESCE" ... "COLLECT" ... "COVAR_POP" ... "COVAR_SAMP" ... "CUME_DIST" ... "COUNT" ... "CURRENT_DATE" ... "CURRENT_TIME" ... "CURRENT_TIMESTAMP" ... "DENSE_RANK" ... "ELEMENT" ... "EXP" ... "FIRST_VALUE" ... "FUSION" ... "GROUPING" ... "LAST_VALUE" ... "LN" ... "LOCALTIME" ... "LOCALTIMESTAMP" ... "LOWER" ... "MAX" ... "MIN" ... "MOD" ... "NULLIF" ... "OCTET_LENGTH" ... "PERCENT_RANK" ... "POWER" ... "RANK" ... "REGR_SXX" ... "REGR_SYY" ... "ROW_NUMBER" ... "SQRT" ... "STDDEV_POP" ... "STDDEV_SAMP" ... "SUM" ... "UPPER" ... "VAR_POP" ... "VAR_SAMP" ... "CURRENT_CATALOG" ... "CURRENT_DEFAULT_TRANSFORM_GROUP" ... "CURRENT_PATH" ... "CURRENT_ROLE" ... "CURRENT_SCHEMA" ... "CURRENT_USER" ... "SESSION_USER" ... "SYSTEM_USER" ... "USER" ... "NEW" ... "CASE" ... "NEXT" ... "CURRENT" ... "CURSOR" ... "ROW" ... "NOT" ... "EXISTS" ... "(" ..
Many tks!!
bin.li
Re: Encountered "day" at line 1, column 8. Was expecting one of:
"UNION" ... "INTERSECT" ..
Posted by yu feng <ol...@gmail.com>.
Because day is a keyword in calcite(such as extract(day from col)),so you
need use double quote on both sides of day, so in kylin all column is
capital word, you need write this column like "DAY", year、month are the
same format.
hope it works for you.
2016-03-23 11:47 GMT+08:00 Bin.Li <bi...@qq.com>:
> hello,
>
> Day is a partition field(string, eg: 20160322), and its a dimision in my
> cube, but when I query 'group by day', I got the following error.
>
> What the problem is ??
>
> ERROR MSG:
>
> Encountered "day" at line 1, column 8. Was expecting one of: "UNION" ...
> "INTERSECT" ... "EXCEPT" ... "ORDER" ... "LIMIT" ... "OFFSET" ... "FETCH"
> ... "STREAM" ... "DISTINCT" ... "ALL" ... "*" ... "+" ... "-" ...
> <UNSIGNED_INTEGER_LITERAL> ... <DECIMAL_NUMERIC_LITERAL> ...
> <APPROX_NUMERIC_LITERAL> ... <BINARY_STRING_LITERAL> ...
> <PREFIXED_STRING_LITERAL> ... <QUOTED_STRING> ... <UNICODE_STRING_LITERAL>
> ... "TRUE" ... "FALSE" ... "UNKNOWN" ... "NULL" ... <LBRACE_D> ...
> <LBRACE_T> ... <LBRACE_TS> ... "DATE" ... "TIME" ... "TIMESTAMP" ...
> "INTERVAL" ... "?" ... "CAST" ... "EXTRACT" ... "POSITION" ... "CONVERT"
> ... "TRANSLATE" ... "OVERLAY" ... "FLOOR" ... "CEIL" ... "CEILING" ...
> "SUBSTRING" ... "TRIM" ... <LBRACE_FN> ... "MULTISET" ... "ARRAY" ...
> "SPECIFIC" ... <IDENTIFIER> ... <QUOTED_IDENTIFIER> ...
> <BACK_QUOTED_IDENTIFIER> ... <BRACKET_QUOTED_IDENTIFIER> ...
> <UNICODE_QUOTED_IDENTIFIER> ... "ABS" ... "AVG" ... "CARDINALITY" ...
> "CHAR_LENGTH" ... "CHARACTER_LENGTH" ... "COALESCE" ... "COLLECT" ...
> "COVAR_POP" ... "COVAR_SAMP" ... "CUME_DIST" ... "COUNT" ... "CURRENT_DATE"
> ... "CURRENT_TIME" ... "CURRENT_TIMESTAMP" ... "DENSE_RANK" ... "ELEMENT"
> ... "EXP" ... "FIRST_VALUE" ... "FUSION" ... "GROUPING" ... "LAST_VALUE"
> ... "LN" ... "LOCALTIME" ... "LOCALTIMESTAMP" ... "LOWER" ... "MAX" ...
> "MIN" ... "MOD" ... "NULLIF" ... "OCTET_LENGTH" ... "PERCENT_RANK" ...
> "POWER" ... "RANK" ... "REGR_SXX" ... "REGR_SYY" ... "ROW_NUMBER" ...
> "SQRT" ... "STDDEV_POP" ... "STDDEV_SAMP" ... "SUM" ... "UPPER" ...
> "VAR_POP" ... "VAR_SAMP" ... "CURRENT_CATALOG" ...
> "CURRENT_DEFAULT_TRANSFORM_GROUP" ... "CURRENT_PATH" ... "CURRENT_ROLE" ...
> "CURRENT_SCHEMA" ... "CURRENT_USER" ... "SESSION_USER" ... "SYSTEM_USER"
> ... "USER" ... "NEW" ... "CASE" ... "NEXT" ... "CURRENT" ... "CURSOR" ...
> "ROW" ... "NOT" ... "EXISTS" ... "(" ..
>
>
> Many tks!!
>
> bin.li
>