[jira] [Created] (KYLIN-2670) CASE WHEN supporting problem in kylin2.0

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (KYLIN-2670) CASE WHEN supporting problem in kylin2.0

JIRA jira@apache.org
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)