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 <[email protected]>: > 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 >
