Dong Li created KYLIN-1682: ------------------------------ Summary: Wrong cuboid is chosen when join with subquery Key: KYLIN-1682 URL: https://issues.apache.org/jira/browse/KYLIN-1682 Project: Kylin Issue Type: Bug Components: Query Engine Affects Versions: v1.5.1 Reporter: Dong Li Assignee: liyang Priority: Minor
In order to filter with top-n, tableau 9.2.6 will generate sql query like this: SELECT KYLIN_SALES.LEAF_CATEG_ID ,"KYLIN_SALES"."LSTG_FORMAT_NAME" AS "LSTG_FORMAT_NAME", (CASE WHEN (NOT ("t0"."XTableau_join_flag" IS NULL)) THEN 1 WHEN NOT (NOT ("t0"."XTableau_join_flag" IS NULL)) THEN 0 ELSE NULL END) AS "io_Set_B_nk" FROM "DEFAULT"."KYLIN_SALES" "KYLIN_SALES" LEFT JOIN ( SELECT "KYLIN_SALES"."LSTG_FORMAT_NAME" AS "LSTG_FORMAT_NAME", COUNT(1) AS "XTableau_join_flag", SUM("KYLIN_SALES"."PRICE") AS "X__alias__A" FROM "DEFAULT"."KYLIN_SALES" "KYLIN_SALES" GROUP BY "KYLIN_SALES"."LSTG_FORMAT_NAME" ORDER BY 3 DESC LIMIT 2 ) "t0" ON (("KYLIN_SALES"."LSTG_FORMAT_NAME" = "t0"."LSTG_FORMAT_NAME") OR (("KYLIN_SALES"."LSTG_FORMAT_NAME" IS NULL) AND ("t0"."LSTG_FORMAT_NAME" IS NULL))) GROUP BY KYLIN_SALES.LEAF_CATEG_ID, "KYLIN_SALES"."LSTG_FORMAT_NAME", (CASE WHEN (NOT ("t0"."XTableau_join_flag" IS NULL)) THEN 1 WHEN NOT (NOT ("t0"."XTableau_join_flag" IS NULL)) THEN 0 ELSE NULL END) There're 2 dimensions in this query: LEAF_CATEG_ID,LSTG_FORMAT_NAME, but the chosen cuboid is [2], which only contains LSTG_FORMAT_NAME. So in the resultset, the LEAF_CATEG_ID column get empty values. BTW, data set is from sample.sh - learn_kylin. -- This message was sent by Atlassian JIRA (v6.3.4#6332)