|

楼主 |
发表于 2018-6-1 11:45:13
|
显示全部楼层
这是我的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
|
|