[
https://issues.apache.org/jira/browse/KYLIN-2670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16049931#comment-16049931
]
zhou degao commented on KYLIN-2670:
-----------------------------------
Also you can test this case in learn_kylin project you can get the same result:
select "fact_pv_data_alias"."LSTG_FORMAT_NAME" as "c0",
"fact_pv_data_alias"."OPS_REGION" as "c1" from "DEFAULT"."KYLIN_SALES" as
"fact_pv_data_alias" group by "fact_pv_data_alias"."LSTG_FORMAT_NAME",
"fact_pv_data_alias"."OPS_REGION" order by CASE WHEN
"fact_pv_data_alias"."LSTG_FORMAT_NAME" IS NULL THEN 1 ELSE 0 END,
"fact_pv_data_alias"."LSTG_FORMAT_NAME" ASC, CASE WHEN
"fact_pv_data_alias"."OPS_REGION" IS NULL THEN 1 ELSE 0 END,
"fact_pv_data_alias"."OPS_REGION" ASC
Error while executing SQL "select "fact_pv_data_alias"."LSTG_FORMAT_NAME" as
"c0", "fact_pv_data_alias"."OPS_REGION" as "c1" from "DEFAULT"."KYLIN_SALES" as
"fact_pv_data_alias" group by "fact_pv_data_alias"."LSTG_FORMAT_NAME",
"fact_pv_data_alias"."OPS_REGION" order by CASE WHEN
"fact_pv_data_alias"."LSTG_FORMAT_NAME" IS NULL THEN 1 ELSE 0 END,
"fact_pv_data_alias"."LSTG_FORMAT_NAME" ASC, CASE WHEN
"fact_pv_data_alias"."OPS_REGION" IS NULL THEN 1 ELSE 0 END,
"fact_pv_data_alias"."OPS_REGION" ASC LIMIT 50000": index (2) must be less than
size (2)
> CASE WHEN supporting problem in kylin2.0
> ----------------------------------------
>
> Key: KYLIN-2670
> URL: https://issues.apache.org/jira/browse/KYLIN-2670
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: v2.0.0
> Reporter: zhou degao
> Assignee: liyang
>
> Following query failed in kylin 2.0 but succeeded in kylin 1.6
> select "fact_pv_data_alias"."PRODUCT_NAME" as "c0",
> "fact_pv_data_alias"."PLATFORM" as "c1" from "CSDNBI"."FACT_PV_DATA" as
> "fact_pv_data_alias" group by "fact_pv_data_alias"."PRODUCT_NAME",
> "fact_pv_data_alias"."PLATFORM" order by CASE WHEN
> "fact_pv_data_alias"."PRODUCT_NAME" IS NULL THEN 1 ELSE 0 END,
> "fact_pv_data_alias"."PRODUCT_NAME" ASC, CASE WHEN
> "fact_pv_data_alias"."PLATFORM" IS NULL THEN 1 ELSE 0 END,
> "fact_pv_data_alias"."PLATFORM" ASC
> Reported error in kylin 2.0:
> Error while executing SQL "select "fact_pv_data_alias"."PRODUCT_NAME" as
> "c0", "fact_pv_data_alias"."PLATFORM" as "c1" from "CSDNBI"."FACT_PV_DATA" as
> "fact_pv_data_alias" group by "fact_pv_data_alias"."PRODUCT_NAME",
> "fact_pv_data_alias"."PLATFORM" order by CASE WHEN
> "fact_pv_data_alias"."PRODUCT_NAME" IS NULL THEN 1 ELSE 0 END,
> "fact_pv_data_alias"."PRODUCT_NAME" ASC, CASE WHEN
> "fact_pv_data_alias"."PLATFORM" IS NULL THEN 1 ELSE 0 END,
> "fact_pv_data_alias"."PLATFORM" ASC LIMIT 50000": index (2) must be less than
> size (2)
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
