在kylin2.0.0中我使用如下语句会报错，但是在kylin1.6.0中就可以执行成功。 select "MAIN_ORDER_VIEW"."CHANNEL_ID" as "c0" from "MAIN_ORDER_VIEW" as "MAIN_ORDER_VIEW" group by "MAIN_ORDER_VIEW"."CHANNEL_ID" order by *CASE WHEN "MAIN_ORDER_VIEW"."CHANNEL_ID" IS NULL THEN 1 ELSE 0 END*, "MAIN_ORDER_VIEW"."CHANNEL_ID" ASC
如果我修改为如下语句在kylin2.0.0中执行成功，我想知道这个是什么原因，不支持when case？ select "MAIN_ORDER_VIEW"."CHANNEL_ID" as "c0" from "MAIN_ORDER_VIEW" as "MAIN_ORDER_VIEW" group by "MAIN_ORDER_VIEW"."CHANNEL_ID" order by 1, "MAIN_ORDER_VIEW"."CHANNEL_ID" ASC -- View this message in context: http://apache-kylin.74782.x6.nabble.com/kylin-when-case-tp8305.html Sent from the Apache Kylin mailing list archive at Nabble.com.
