Seems like a bug, please open a JIRA to track. Also please share complete error log to debug.
On Mon, Jun 26, 2017 at 11:27 AM, snail_wjk <[email protected]> wrote: > 在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. >
