Open deathzu999 opened 1 month ago
version: 1.0.0-rc.3 SQL:SELECT FROM ( WITH RankedResults AS (select , ROW_NUMBER() OVER (PARTITION BY formatted_create_dt ORDER BY member_user_cnt DESC) AS rn from (SELECT DATE_FORMAT(create_dt, '%Y-%m-%d') AS formatted_create_dt, b.language_name, COUNT(DISTINCT CASE WHEN action_type = 'member' THEN user_id END) AS member_user_cnt, COUNT(DISTINCT CASE WHEN action_type = 'left' THEN user_id END) AS left_user_cnt, COUNT(DISTINCT CASE WHEN action_type = 'member' THEN user_id END) - COUNT(DISTINCT CASE WHEN action_type = 'left' THEN user_id END) AS net_incre_cnt FROM dc_collect_channel a LEFT JOIN language_map_info b ON a.language = b.language_short_name WHERE create_dt >= $ST_DATE$ and create_dt <= $END_DATE$ AND b.language_name IS NOT NULL GROUP BY formatted_create_dt, b.language_name) m) SELECT formatted_create_dt '日期',language_name '语言',member_user_cnt '进入用户数',left_user_cnt '离开用户数' FROM RankedResults WHERE rn <= 10 ORDER BY formatted_create_dt desc,member_user_cnt desc ) AS DATART_VTABLE LIMIT 1000 OFFSET 0 DB: MYSQL EXCEPTION:org.apache.calcite.sql.parser.SqlParseException: Encountered ". language" at line 1, column 975. Was expecting one of: "EXCEPT" ... "FETCH" ... "GROUP" ... "HAVING" ... "INTERSECT" ... "LIMIT" ... "OFFSET" ... "ORDER" ... "MINUS" ... "UNION" ... "WHERE" ... "WINDOW" ... ")" ... "NATURAL" ... "JOIN" ... "INNER" ... "LEFT" ... "RIGHT" ... "FULL" ... "CROSS" ... "," ... "OUTER" ... "." ... "." ... "." ... "." ... "." ... "." ... "NOT" ... "IN" ... "<" ... "<=" ... ">" ... ">=" ... "=" ... "<>" ... "!=" ... "BETWEEN" ... "LIKE" ... "SIMILAR" ... "+" ... "-" ... "" ... "/" ... "%" ... "||" ... "AND" ... "OR" ... "IS" ... "MEMBER" ... "SUBMULTISET" ... "CONTAINS" ... "OVERLAPS" ... "EQUALS" ... "PRECEDES" ... "SUCCEEDS" ... "IMMEDIATELY" ... "MULTISET" ... "&" ... "[" ... "FORMAT" ... "." ... "." "" ... "(" ...
DATART_VTABLE
version: 1.0.0-rc.3 SQL:SELECT FROM ( WITH RankedResults AS (select , ROW_NUMBER() OVER (PARTITION BY formatted_create_dt ORDER BY member_user_cnt DESC) AS rn from (SELECT DATE_FORMAT(create_dt, '%Y-%m-%d') AS formatted_create_dt, b.language_name, COUNT(DISTINCT CASE WHEN action_type = 'member' THEN user_id END) AS member_user_cnt, COUNT(DISTINCT CASE WHEN action_type = 'left' THEN user_id END) AS left_user_cnt, COUNT(DISTINCT CASE WHEN action_type = 'member' THEN user_id END) - COUNT(DISTINCT CASE WHEN action_type = 'left' THEN user_id END) AS net_incre_cnt FROM dc_collect_channel a LEFT JOIN language_map_info b ON a.language = b.language_short_name WHERE create_dt >= $ST_DATE$ and create_dt <= $END_DATE$ AND b.language_name IS NOT NULL GROUP BY formatted_create_dt, b.language_name) m) SELECT formatted_create_dt '日期',language_name '语言',member_user_cnt '进入用户数',left_user_cnt '离开用户数' FROM RankedResults WHERE rn <= 10 ORDER BY formatted_create_dt desc,member_user_cnt desc ) AS ...
"." ...
"." ...
"." ...
"." ...
"." ...
"NOT" ...
"IN" ...
"<" ...
"<=" ...
">" ...
">=" ...
"=" ...
"<>" ...
"!=" ...
"BETWEEN" ...
"LIKE" ...
"SIMILAR" ...
"+" ...
"-" ...
"" ...
"/" ...
"%" ...
"||" ...
"AND" ...
"OR" ...
"IS" ...
"MEMBER" ...
"SUBMULTISET" ...
"CONTAINS" ...
"OVERLAPS" ...
"EQUALS" ...
"PRECEDES" ...
"SUCCEEDS" ...
"IMMEDIATELY" ...
"MULTISET" ...
"&" ...
"[" ...
"FORMAT" ...
"." ...
"." "" ...
"(" ...
DATART_VTABLE
LIMIT 1000 OFFSET 0 DB: MYSQL EXCEPTION:org.apache.calcite.sql.parser.SqlParseException: Encountered ". language" at line 1, column 975. Was expecting one of: "EXCEPT" ... "FETCH" ... "GROUP" ... "HAVING" ... "INTERSECT" ... "LIMIT" ... "OFFSET" ... "ORDER" ... "MINUS" ... "UNION" ... "WHERE" ... "WINDOW" ... ")" ... "NATURAL" ... "JOIN" ... "INNER" ... "LEFT" ... "RIGHT" ... "FULL" ... "CROSS" ... "," ... "OUTER" ... "."