You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by snail_wjk <sa...@126.com> on 2017/06/26 03:27:54 UTC
kylin when case
在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.
Re: kylin when case
Posted by Li Yang <li...@apache.org>.
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 <sa...@126.com> 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.
>