起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 4656|回复: 4

[结贴] ksql中的判断逻辑

[复制链接]

42

主题

110

帖子

422

积分

中级会员

Rank: 3Rank: 3

积分
422
QQ
发表于 2018-6-1 11:04:31 | 显示全部楼层 |阅读模式
ksql中判断逻辑使用case when...then,还是用什么啊?用case when总是报错,有什么注意点吗

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36185
发表于 2018-6-1 11:30:14 | 显示全部楼层
报错发具体的错误信息
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

42

主题

110

帖子

422

积分

中级会员

Rank: 3Rank: 3

积分
422
QQ
 楼主| 发表于 2018-6-1 11:45:13 | 显示全部楼层
jishuang 发表于 2018-6-1 11:30
报错发具体的错误信息

这是我的case when:select case when b2.fprovince<>'pth' then b2.fprovince='全国' end as fprovince from.....下面是报错信息
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select case when b2.fprovince<>'pth' then b2.fprovince='全国' end as fprovince,b2.fcity,b2.bst,round((b2.bst-b2.cst)/b2.cst*100,2)as compc, b2.bst1, round((b2.bst1-b2.cst1)/b2.cst1*100,2)as compc1, b2.bst2,round((b2.bst2-b2.cst2)/b2.cst2*100,2)as compc2 from (select b1.fprovince as fprovince,b1.fcity as fcity,b1.ftime as ftime,b1.bst as bst, c1.cst as cst,b1.bst1 as bst1,b1.bst2 as bst2,c1.cst1 as cst1,c1.cst2 as cst2 from (select b.fprovince as fprovince,b.fcity as fcity,b.ftime as ftime,sum(b.total) as bst,sum(b.sum1) as bst1,sum(b.sum2) as bst2 from( select FI_FY.fprovince as fprovince,FI_FY.fcity as fcity,SQL.year(FI_FY.fpayTime) as ftime,sum(FI_FY.fCLF) as total,sum(FI_FY.fZF) as sum1,sum(FI_FY.fQTFY) as sum2 from FI_FY FI_FY where (SQL.date_format(FI_FY.fpayTime,'%Y')=:year)  group by FI_FY.fpayTime order by FI_FY.fprovince) b group by b.ftime)b1 optional join (select c.fprovince as fprovince,c.fcity as fcity,sum(c.total) as cst,sum(c.sum1) as cst1,sum(c.sum2) as cst2 from( select FI_FY.fprovince as fprovince,FI_FY.fcity as fcity,SQL.year(FI_FY.fpayTime) as ftime,sum(FI_FY.fCLF) as total,sum(FI_FY.fZF) as sum1,sum(FI_FY.fQTFY) as sum2 from FI_FY FI_FY where  (SQL.date_format(FI_FY.fpayTime,'%Y')=:year2) group by FI_FY.fpayTime order by FI_FY.fprovince) c group by c.ftime )c1 on b1.fcity = c1.fcity)b2 limit 0,20
--> 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 Warehouse.queryFI_FY123(Warehouse.java:946)
        ... 27 more
Caused by: com.justep.exception.KSQLException: 编码: JUSTEP154115; 提示: KSQL语法错误, en b2.fprovince^^='全国' end as fp中未找到需要的元素, 位置54期望是END
        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.caseNode(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)
        ... 32 more
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36185
发表于 2018-6-1 11:51:29 | 显示全部楼层
语法不正确
ksql.png
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

42

主题

110

帖子

422

积分

中级会员

Rank: 3Rank: 3

积分
422
QQ
 楼主| 发表于 2018-6-1 11:55:18 | 显示全部楼层

ok,结贴吧
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2025-7-12 02:33 , Processed in 0.053666 second(s), 26 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表