On Tue, Jun 14, 2016 at 12:08 PM, lxw <[email protected]> wrote: > got a problem about query samle cube table "KYLIN_SALES" > The cube SQL is : > > SELECT > KYLIN_SALES.PART_DT > ,KYLIN_SALES.LEAF_CATEG_ID > ,KYLIN_SALES.LSTG_SITE_ID > ,KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME > ,KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME > ,KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME > ,KYLIN_SALES.LSTG_FORMAT_NAME > ,KYLIN_SALES.PRICE > ,KYLIN_SALES.SELLER_ID > FROM DEFAULT.KYLIN_SALES as KYLIN_SALES > INNER JOIN DEFAULT.KYLIN_CAL_DT as KYLIN_CAL_DT > ON KYLIN_SALES.PART_DT = KYLIN_CAL_DT.CAL_DT > INNER JOIN DEFAULT.KYLIN_CATEGORY_GROUPINGS as KYLIN_CATEGORY_GROUPINGS > ON KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND > KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID > > My query SQL1 （works OK）: > > SELECT > KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME, > SUM(price) as sum__price > FROM KYLIN_SALES as KYLIN_SALES > INNER JOIN KYLIN_CATEGORY_GROUPINGS as KYLIN_CATEGORY_GROUPINGS > ON KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND > KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID > GROUP BY KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME > > My query SQL2 (works OK) : > > SELECT > KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME, > SUM(price) as sum__price > FROM KYLIN_SALES as KYLIN_SALES > INNER JOIN (SELECT * FROM KYLIN_CATEGORY_GROUPINGS) as > KYLIN_CATEGORY_GROUPINGS > ON KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND > KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID > GROUP BY KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME; > > My query SQL3 (No data result) : > SELECT > KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME, > SUM(price) as sum__price > FROM KYLIN_SALES as KYLIN_SALES > INNER JOIN (SELECT LEAF_CATEG_ID, SITE_ID,META_CATEG_NAME FROM > KYLIN_CATEGORY_GROUPINGS) as KYLIN_CATEGORY_GROUPINGS > ON KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND > KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID > GROUP BY KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME > > What's different from SQL2 and SQL3? > But in my custom Cube, the query like SQL3 also works OK. > > Thanks! >
hi we're planning to answer all similar questions with single one JIRA: https://issues.apache.org/jira/browse/KYLIN-1792, please stay tuned -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone
