ksql 错误

MENG1

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select a.lecturer_empno,(CASE WHEN (sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1))-SQL.CAST(sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1) AS int)<0.5 AND (sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1))-SQL.CAST(sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1) AS int)>0 THEN SQL.CAST(SQL.CAST(sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1) AS int) AS decimal)+ 0.5 WHEN SQL.CAST(sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1) AS int)-(sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1)) = 0.5 THEN (sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1)) ELSE SQL.CAST(sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1)AS int) END)AS totaltime,(CASE WHEN (sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1))-SQL.CAST(sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1) AS int)<0.5 AND (sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1))-SQL.CAST(sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1) AS int)>0 THEN SQL.CAST(SQL.CAST(sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1) AS int) AS decimal)+ 0.5 WHEN SQL.CAST(sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1) AS int)-(sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1)) = 0.5 THEN (sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1)) ELSE SQL.CAST(sum(SQL.NVL(a.duration, 0)+ SQL.NVL(a.out_duration, 0))/(LENGTH(REPLACE(a.lecturer_empno, ';', ';;'))-LENGTH(a.lecturer_empno)+ 1)AS int) END)* 2 AS credit from train_apply a where a.flow_id in ('FlowEndNode    ') and a.classtype = 1  and a.lecturer_empno like '%000972%' group by a.lecturer_empno
--> sql:
--> binds: []
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.KSQL.select(Unknown Source)
at Score.queryOracleMysql(Score.java:76)
... 30 more
Caused by: com.justep.exception.KSQLException: 编码: JUSTEP154115; 提示: KSQL语法错误, rer_empno)+ 1) ^^AS int)<0.5 AND中未找到需要的元素, 位置308期望是)
at com.justep.exception.KSQLException.create(Unknown Source)
at com.justep.system.ksql.token.TokenManager.matchToken(Unknown Source)
at com.justep.system.ksql.token.TokenManager.match(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.localSqlFunctionExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.unaryExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.multiExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.addExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.compExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.notExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.andExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.orExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.whenNode(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.caseNode(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.unaryExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.multiExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.addExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.compExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.notExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.andExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.orExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.unaryExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.multiExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.addExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.selectColumn(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.selectListNode(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
... 35 more

MENG1

这是KSQL语句

MENG1

上述代码去点个别函数前的SQL.之后，执行SQL语句是没有问题的

jishuang

把<0.5改为=执行看看

不行就用sql实现，KSQL对目前情况的转换可能有问题