Ksql报错要怎么修改？

123qwe

1. <action process="/dealer/dealer/process/dealer/dealerProcess" activity="dealerActivity" name="getDealerOrServiceDataAction" execute-context="" content-type="application/xml"><parameters><parameter name="filter"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">DE_ServiceDealerM.fName like '%155%' or DE_ServiceDealerD.fLocation like '%155%'</xbiz:simple></parameter><parameter name="currentLat"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#Decimal">25.070557</xbiz:simple></parameter><parameter name="province"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">云南省</xbiz:simple></parameter><parameter name="evaOrder"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">DESC</xbiz:simple></parameter><parameter name="currentLon"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#Decimal">102.670279</xbiz:simple></parameter><parameter name="city"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">昆明市</xbiz:simple></parameter><parameter name="ranOrder"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">ASC</xbiz:simple></parameter><parameter name="typeCode"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">0</xbiz:simple></parameter></parameters></action>
   
2. java.lang.reflect.InvocationTargetException
   
3.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   
4.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   
5.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   
6.     at java.lang.reflect.Method.invoke(Method.java:497)
   
7.     at com.justep.system.action.Engine.invokeActions(Native Method)
   
8.     at com.justep.system.action.Engine.invokeActions(Unknown Source)
   
9.     at com.justep.business.server.BusinessServer.doAction(Unknown Source)
   
10.     at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
    
11.     at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
12.     at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
13.     at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    
14.     at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
15.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
16.     at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
17.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
18.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
19.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
20.     at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
    
21.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    
22.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
23.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
24.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
25.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
26.     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
27.     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
28.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
29.     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
30.     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
31.     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
32.     at java.lang.Thread.run(Thread.java:745)
    
33. Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select DE_ServiceDealer.* from (SELECT DE_ServiceDealerM AS fMasterID, DE_ServiceDealerM.fTypeCode AS fTypeCode, DE_ServiceDealerM.fTypeName AS fTypeName, DE_ServiceDealerM.fCategoryCode AS fCategoryCode, DE_ServiceDealerM.fCategory AS fCategory, DE_ServiceDealerM.fCreateDate AS fCreateDate, DE_ServiceDealerM.fParentID AS fParentID, DE_ServiceDealerM.fCode AS fCode, DE_ServiceDealerM.fName AS fName, DE_ServiceDealerM.fGrade AS fGrade, DE_ServiceDealerM.fScore AS fScore, DE_ServiceDealerD AS fDealerID, DE_ServiceDealerD.fProvince AS fProvince, DE_ServiceDealerD.fCity AS fCity, DE_ServiceDealerD.fArea AS fArea, DE_ServiceDealerD.fLocation AS fLocation, DE_ServiceDealerD.fContacts AS fContacts, DE_ServiceDealerD.fTellphone AS fTellphone, DE_ServiceDealerD.fLongitude AS fLongitude, DE_ServiceDealerD.fLatitude AS fLatitude FROM DE_ServiceDealerD DE_ServiceDealerD optional join DE_ServiceDealerM DE_ServiceDealerM ON DE_ServiceDealerM = DE_ServiceDealerD.fMasterID) DE_ServiceDealer where  DE_ServiceDealer.fDealerID = '1111919F22D0448C9F382FB16836B111'
    
34. --> sql:
    
35. --> binds: []
    
36.     at com.justep.exception.BusinessException.create(Unknown Source)
    
37.     at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
38.     at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
39.     at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
40.     at com.justep.system.data.KSQL.select(Unknown Source)
    
41.     at Dealer.getDealerOrStationTableAll(Dealer.java:458)
    
42.     at Dealer.getDealerOrServiceData(Dealer.java:228)
    
43.     ... 30 more
    
44. Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154062; 提示: KSQL语法错误, DE_ServiceDealer期望是QUERY_ALIAS, 实际是CONCEPT_ALIAS
    
45.     at com.justep.exception.BusinessException.create(Unknown Source)
    
46.     at com.justep.util.Utils.check(Unknown Source)
    
47.     at com.justep.system.ksql.parser.AbstractParser.joinedExpression(Unknown Source)
    
48.     at com.justep.system.ksql.parser.AbstractParser.fromNode(Unknown Source)
    
49.     at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source)
    
50.     at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
    
51.     at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
    
52.     at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
    
53.     ... 36 more
    
54. 
    

复制代码

这个ksql要怎么修改？

jishuang

ksql中from后面的不能用子查询


如果要用子查询就自己用sql实现，或者用视图实现，视图反向生成为概念

123qwe

jishuang 发表于 2018-8-20 15:27
ksql中from后面的不能用子查询

结贴