version: 1.0.0-rc.3
SQL:SELECT * FROM ( select (sum(DATEDIFF(hour,sqrq,ExamDate))/24) 等待天数,count()人数 from ( select * from AnyImageV5.[grid].[BHosCheckES] where CrtDate>=$KSRQ$ and CrtDate<$JSRQ$ and (ExamItems like '%纤维胃镜检查%' or ExamItems like '%纤维结肠镜检查%') and InPatNo is not null and InPatNo<>'' and exists (select 1 from (select * from openquery(NEWHIS, 'select * from BZHIS.ZYGL_DXSF b where ( ym like ''全身麻醉%'' or ym like ''无插管全麻%''） and sfrq>=''2024-01-01 00:00:00'' and b.KSBH in (''2010903'',''1031200'',''1021100'') ') s) b where ypid in('017819','009237') and InPatNo=b.BLH and visitid=b.zycs )) a inner join MedcareES..预约登记 b on a.BookID =b.编号 and ExamDate>='2024-01-01' and ExamDate<='2024-02-01' inner join (select * from openquery(NEWHIS, 'select * from zygl_jcsqd where (xmmc like ''%纤维胃镜检查%'' or xmmc like ''%纤维结肠镜检查%'' or xmmc like ''%纤维支气管%'') and sqrq>=''2024-01-01 00:00:00'' ')) c on c.yzid=b.医嘱号 ) AS [DATART_VTABLE]
DB: MSSQL
EXCEPTION:org.apache.calcite.sql.parser.SqlParseException: Encountered "hour ," at line 1, column 39.
Was expecting one of:
"ALL" ...
"CURSOR" ...
"DISTINCT" ...
"EXISTS" ...
"NOT" ...
"ROW" ...
"WITH" ...
"(" ...
"+" ...
"-" ...
...
<HYPHENATED_IDENTIFIER> ...
<QUOTED_IDENTIFIER> ...
<BACK_QUOTED_IDENTIFIER> ...
<BRACKET_QUOTED_IDENTIFIER> ...
<UNICODE_QUOTED_IDENTIFIER> ...
"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" ...
"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" ...
"EVERY" ...
"EXP" ...
"FIRST_VALUE" ...
"FUSION" ...
"INTERSECTION" ...
"GROUPING" ...
"HOUR" "(" ...
"CURRENT_CATALOG" ...
"CURRENT_DEFAULT_TRANSFORM_GROUP" ...
"CURRENT_PATH" ...
"CURRENT_ROLE" ...
"CURRENT_SCHEMA" ...
"CURRENT_USER" ...
"LOCALTIME" ...
"LOCALTIMESTAMP" ...
"SESSION_USER" ...
"SYSTEM_USER" ...
"USER" ...
"NEW" ...
"CASE" ...
"CURRENT" ...
"" ...
")" ...