自定义action中ksql使用操作符union报错

Vooruit

KSQL: SELECT FY_ORDER_HEAD.*,FY_ORDER_HEAD as ORDER_NO,(select  case when :currentLanguage() = 'zh_CN' then FY_ARG_DICT.NAME_ZH_CN else FY_ARG_DICT.NAME_EN_US end  from FY_ARG_DICT FY_ARG_DICT  where  FY_ARG_DICT.TYPE = 'TRANS_MODE' AND FY_ARG_DICT.VALUE = FY_ORDER_HEAD.TRANS_MODE ) as TRANS_MODE,(select  case when :currentLanguage() = 'zh_CN' then FY_ARG_DICT.NAME_ZH_CN else FY_ARG_DICT.NAME_EN_US end  from FY_ARG_DICT FY_ARG_DICT  where  FY_ARG_DICT.TYPE = 'VEHICLE_ARRANGES' AND FY_ARG_DICT.VALUE = FY_ORDER_HEAD.VEHICLE_ARRANGES ) as VEHICLE_ARRANGES,FY_ARG_DICT1.NAME_ZH_CN as TRANS_MODE_NAME,FY_ARG_DICT1.NAME_EN_US as TRANS_MODE_NAME_EN,FY_ARG_DICT2.NAME_ZH_CN as VEHICLE_ARRANGES_NAME,FY_ARG_DICT2.NAME_EN_US as VEHICLE_ARRANGES_NAME_EN,case when ORDER_LINE_COUNT.statusCount is null then 0 else ORDER_LINE_COUNT.statusCount end as statusCount  FROM FY_ORDER_HEAD FY_ORDER_HEAD  optional  join (select  count(0) as statusCount, FY_ORDER_LINE.ORDER_NO as ORDER_NO from FY_ORDER_LINE FY_ORDER_LINE  where FY_ORDER_LINE.ORDER_LINE_STATUS = 'PLACE'  group by FY_ORDER_LINE.ORDER_NO) ORDER_LINE_COUNT on ORDER_LINE_COUNT.ORDER_NO = FY_ORDER_HEAD optional  join FY_ARG_DICT FY_ARG_DICT1 on FY_ARG_DICT1.VALUE = FY_ORDER_HEAD.TRANS_MODE AND FY_ARG_DICT1.TYPE = 'TRANS_MODE' optional  join FY_ARG_DICT FY_ARG_DICT2 on FY_ARG_DICT2.VALUE = FY_ORDER_HEAD.VEHICLE_ARRANGES AND FY_ARG_DICT2.TYPE = 'VEHICLE_ARRANGES' WHERE (( FY_ORDER_HEAD in(select distinct FY_ORDER_LINE.ORDER_NO as ORDER_NO from FY_ORDER_LINE FY_ORDER_LINE  where FY_ORDER_LINE.ORDER_LINE_STATUS = 'PLACE' and FY_ORDER_LINE.APPOINT_SUB_COMP = 'WDG' union select distinct FY_ORDER_LINE.ORDER_NO as ORDER_NO from FY_ORDER_LINE FY_ORDER_LINE  where FY_ORDER_LINE.ORDER_LINE_STATUS != 'PLACE' and FY_ORDER_LINE.ALLOT_SUB_COMP = 'WDG'))) ORDER BY THIRD_ORDER_DATE ASC LIMIT 0, 10

jishuang

复杂的语句推荐用sql实现
ksql中用union 在某些情况下有问题

Vooruit

jishuang 发表于 2018-2-6 14:48
复杂的语句推荐用sql实现
ksql中用union 在某些情况下有问题

那这个错误可以看得出吗，因为开始业务需求并不用合集，没有使用union执行代码是没报错的。

jishuang

应该是ksql目前不支持这样的写法，先用sql实现