后台执行KSQL报错

tange387

执行KSQL报错，但我在数据库里面是可以执行的，数据库是sqlserver2012。以下是ksql代码：

update hr_month_salary ss set ss.fDJBX = a.GRtotal from hr_month_salary as b,(SELECT fNY,fYGBH,fYGXM,sum(fGRJN) as GRtotal FROM hr_scocial where fNY = '2016年8月' group by fNY,fYGBH,fYGXM)as a where b.fNF = '2016' and b.fYF = '8' and b.fYGBH = a.fYGBH


帮看一下是什么原因啊？

tange387

改成KQL该怎么改？

大雁子

参考KSQL语法

tange387

大雁子 发表于 2017-2-16 15:31
参考KSQL语法

这个我看了，但是例子写的子查询比较简单，不明白向我这个该怎么改

jishuang

报错发完整的错误信息

tange387

jishuang 发表于 2017-2-16 16:25
报错发完整的错误信息

调用失败！执行KSQL出错, KSQL: update hr_month_salary a set a.fDJBX = (select fDJBX from (SELECT fNY,fYGBH,fYGXM,sum(fGRJN) as fDJBX FROM hr_scocial p where p.fNY = '2016年8月' group by p.fNY,p.fYGBH,p.fYGXM) as b) where a.fNF = '2016' and a.fYF = '8' and a.fYGBH = b.fYGBH
Error: 调用失败！执行KSQL出错, KSQL: update hr_month_salary a set a.fDJBX = (select fDJBX from (SELECT fNY,fYGBH,fYGXM,sum(fGRJN) as fDJBX FROM hr_scocial p where p.fNY = '2016年8月' group by p.fNY,p.fYGBH,p.fYGXM) as b) where a.fNF = '2016' and a.fYF = '8' and a.fYGBH = b.fYGBH
at Object.justep.Request.sendBizRequest2.callback (http://127.0.0.1:6060/x5/UI/v_2b ... nguage=zh_CN:113:12)
at cbf (http://127.0.0.1:6060/x5/v_0d1f4 ... guage=zh_CN:1:65375)
at Object.sendRequest2 (http://127.0.0.1:6060/x5/v_0d1f4 ... guage=zh_CN:1:65619)
at Object.sendBizRequest2 (http://127.0.0.1:6060/x5/v_0d1f4 ... guage=zh_CN:1:92086)
at Object.mainActivity.trigger2Click (http://127.0.0.1:6060/x5/UI/v_2b ... nguage=zh_CN:106:18)
at .callFunction (http://127.0.0.1:6060/x5/UI/v_89 ... language=zh_CN&$version=53ed2cda-f00a-43be-80aa-a61a9765c65d:808:119)
at .run (http://127.0.0.1:6060/x5/v_0dacf ... uage=zh_CN:1:147984)
at .exec_ (http://127.0.0.1:6060/x5/v_0dacf ... uage=zh_CN:1:331534)
at .execute (http://127.0.0.1:6060/x5/v_0dacf ... uage=zh_CN:1:447916)
at Function.forEach (http://127.0.0.1:6060/x5/v_0dacf ... uage=zh_CN:1:162989)

又改了一下，上面是完整报错信息

tange387

后台异常是这样，应该是语法不对，但我看不出哪里不对也不知道怎么改
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: update hr_month_salary a set a.fDJBX = (select fDJBX from (SELECT fNY,fYGBH,fYGXM,sum(fGRJN) AS fDJBX FROM hr_scocial p where p.fNY = '2016年8月' group by p.fNY,p.fYGBH,p.fYGXM) AS b) where a.fNF = '2016' and a.fYF = '8' and a.fYGBH = b.fYGBH
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlUpdate(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at Salary.updateDJBXandGJJ(Salary.java:1420)
        ... 27 more
Caused by: com.justep.exception.KSQLException: 编码: JUSTEP154115; 提示: KSQL语法错误, fYGBH,p.fYGXM) ^^AS b) where a.f中未找到需要的元素, 位置176期望是<Identifier>
        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.joinedExpression(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.fromNode(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(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.UpdateParser.assignExpression(Unknown Source)
        at com.justep.system.ksql.parser.UpdateParser.setNode(Unknown Source)
        at com.justep.system.ksql.parser.UpdateParser.start(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
        ... 33 more

jishuang

应该是子查询的问题，ksql中用子查询可能会有问题，推荐用sql去实现

tange387

jishuang 发表于 2017-2-16 17:44
应该是子查询的问题，ksql中用子查询可能会有问题，推荐用sql去实现

我是想用sql啊，而且sql代码是没有问题的，问题是我在后台java代码里面该怎么才能执行sql而不是ksql？

tange387

OK，搞定了，请锁帖。
偶尔写一回代码真是坑啊，基本都不会了，还要参考原来的用法。