kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "lxw" <lxw1...@qq.com>
Subject Question about query sample cube table KYLIN_SALES
Date Tue, 14 Jun 2016 04:08:41 GMT
Hi, 

  I 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!
Mime
View raw message