kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yu feng <olaptes...@gmail.com>
Subject Re: Encountered "day" at line 1, column 8. Was expecting one of: "UNION" ... "INTERSECT" ..
Date Wed, 23 Mar 2016 04:45:16 GMT
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 <bingleessdut@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
>

Mime
View raw message