|
楼主 |
发表于 2018-11-29 10:03:33
|
显示全部楼层
本帖最后由 tange387 于 2018-11-29 10:05 编辑
如果用bizdata直接加载查询结果的话,执行的ksql又会报错。ksql如下:
select guid() as fID, gx.fID as fGXID, gx.fGX as fGXMC,gx.fGZL as fZGZL,gx.fZYDW as fDW from GE_GXXX gx,GE_XMJHS jh where jh = gx.fXMIDGX and jh.fXMMC='cq' and jh.fXMPC='5' and gx.fGXLX='22'
错误信息如下:
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select guid() as fID, gx.fID as fGXID, gx.fGX as fGXMC,gx.fGZL as fZGZL,gx.fZYDW as fDW from GE_GXXX gx,GE_XMJHS jh where jh = gx.fXMIDGX and jh.fXMMC='cq' and jh.fXMPC='5' and gx.fGXLX='22'
--> 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 XMJHS.query_GX(XMJHS.java:30)
... 27 more
Caused by: com.justep.exception.KSQLException: 编码: JUSTEP154115; 提示: KSQL语法错误, from GE_GXXX gx^^,GE_XMJHS jh wh中未找到需要的元素, 位置103期望是<EOF>
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.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
|
|