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
