zhou degao created KYLIN-2670:
---------------------------------
Summary: 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)
