version: dev
SQL:SELECT * FROM ( SELECT book_id, start_time, end_time, section_id, ctime, t1.batch_id AS batch_id, new_count, (d1_count1.0/new_count1.0) AS d1_rate, (d2_count1.0/new_count1.0) AS d2_rate, (d3_count1.0/new_count1.0) AS d3_rate, (d4_count1.0/new_count1.0) AS d4_rate, (d5_count1.0/new_count1.0) AS d5_rate, (d6_count1.0/new_count1.0) AS d6_rate, (d7_count1.0/new_count1.0) AS d7_rate, (d8_count1.0/new_count1.0) AS d8_rate, (d9_count1.0/new_count1.0) AS d9_rate, (d10_count1.0/new_count1.0) AS d10_rate, (d11_count1.0/new_count1.0) AS d11_rate, (d12_count1.0/new_count1.0) AS d12_rate, (d13_count1.0/new_count1.0) AS d13_rate, (d14_count1.0/new_count1.0) AS d14_rate FROM (SELECT book_id, start_time, end_time, batch_id, section_id, ctime FROM t_conteval_report ) t1 INNER JOIN (SELECT batch_id, SUM(CASE WHEN dn = 0 THEN count ELSE 0 END) AS new_count, SUM(CASE WHEN dn = 1 THEN count ELSE 0 END) AS d1_count, SUM(CASE WHEN dn = 2 THEN count ELSE 0 END) AS d2_count, SUM(CASE WHEN dn = 3 THEN count ELSE 0 END) AS d3_count, SUM(CASE WHEN dn = 4 THEN count ELSE 0 END) AS d4_count, SUM(CASE WHEN dn = 5 THEN count ELSE 0 END) AS d5_count, SUM(CASE WHEN dn = 6 THEN count ELSE 0 END) AS d6_count, SUM(CASE WHEN dn = 7 THEN count ELSE 0 END) AS d7_count, SUM(CASE WHEN dn = 8 THEN count ELSE 0 END) AS d8_count, SUM(CASE WHEN dn = 9 THEN count ELSE 0 END) AS d9_count, SUM(CASE WHEN dn = 10 THEN count ELSE 0 END) AS d10_count, SUM(CASE WHEN dn = 11 THEN count ELSE 0 END) AS d11_count, SUM(CASE WHEN dn = 12 THEN count ELSE 0 END) AS d12_count, SUM(CASE WHEN dn = 13 THEN count ELSE 0 END) AS d13_count, SUM(CASE WHEN dn = 14 THEN count ELSE 0 END) AS d14_count FROM t_conteval_retent_report GROUP BY batch_id ) t2 ON t1.batch_id = t2.batch_id WHERE t1.batch_id = $BATCHID$ ) AS "DATART_VTABLE" OFFSET 0 ROWS FETCH NEXT 1000 ROWS ONLY
DB: POSTGRESQL
EXCEPTION:org.apache.calcite.sql.parser.SqlParseException: Encountered "count ELSE" at line 1, column 975.
Was expecting one of:
"CURSOR" ...
"EXISTS" ...
"NOT" ...
"ROW" ...
"(" ...
"+" ...
"-" ...
"INTERVAL" ...
<UNSIGNED_INTEGER_LITERAL> ...
<DECIMAL_NUMERIC_LITERAL> ...
<APPROX_NUMERIC_LITERAL> ...
<BINARY_STRING_LITERAL> ...
<PREFIXED_STRING_LITERAL> ...
<QUOTED_STRING> ...
<UNICODE_STRING_LITERAL> ...
<BIG_QUERY_DOUBLE_QUOTED_STRING> ...
<BIG_QUERY_QUOTED_STRING> ...
"TRUE" ...
"FALSE" ...
"UNKNOWN" ...
"NULL" ...
<LBRACE_D> ...
<LBRACE_T> ...
<LBRACE_TS> ...
"DATE" ...
"TIME" ...
"TIMESTAMP" ...
"?" ...
"CAST" ...
"EXTRACT" ...
"POSITION" ...
"CONVERT" ...
"TRANSLATE" ...
"OVERLAY" ...
"FLOOR" ...
"CEIL" ...
"CEILING" ...
"SUBSTRING" ...
"TRIM" ...
"CLASSIFIER" ...
"MATCH_NUMBER" ...
"RUNNING" ...
"PREV" ...
"NEXT" ...
"JSON_EXISTS" ...
"JSON_VALUE" ...
"JSON_QUERY" ...
"JSON_OBJECT" ...
"JSON_OBJECTAGG" ...
"JSON_ARRAY" ...
"JSON_ARRAYAGG" ...
<LBRACE_FN> ...
"MULTISET" ...
"ARRAY" ...
"PERIOD" ...
"SPECIFIC" ...
...
<HYPHENATED_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_CATALOG" ...
"CURRENT_DATE" ...
"CURRENT_DEFAULT_TRANSFORM_GROUP" ...
"CURRENT_PATH" ...
"CURRENT_ROLE" ...
"CURRENT_SCHEMA" ...
"CURRENT_TIME" ...
"CURRENT_TIMESTAMP" ...
"CURRENT_USER" ...
"LOCALTIME" ...
"LOCALTIMESTAMP" ...
"SESSION_USER" ...
"SYSTEM_USER" ...
"USER" ...
"NEW" ...
"CASE" ...
"CURRENT" ...