Hello!
I met some problems when i execute sql in kylin insight。
When i execute the sql below：
SELECT CITY, GOODS_CODE, SUM(SALES_AMT) AMT
FROM PRO.FCT_GOODS_CITY_PROFILE
WHERE "DAY" BETWEEN '2020-08-09' AND '2020-08-15'
AND CITY IN ('武汉')
AND GOODS_CODE IN ('32020959','13089102','24010101','03010182')
GROUP BY CITY, GOODS_CODE;
Kylin just returned 2 records, but it should return 4 records.
The kylin version is 2.6.3.
And the rowkey of the cube has 12 dimensions,
It has 6 mandatory dimensions and they are
ORG_CODE、ORG_GID、ORG_NAME、CITY、MONTH、YEAR.
It also has 5 hierarchy dimensions and they are
YINGYUN_CLASS_ID、CATE1_ID、CATE2_ID、CATE3_ID、GOODS_CODE.
The order of the dimensions in the rowkey is:
DAY、GOODS_CODE、CATE3_ID、CATE2_ID、CATE1_ID、CITY、MONTH、YEAR、ORG_CODE、ORG_GID、ORG_NAME、YINGYUN_CLASS_ID.
I don't know what configed incorrect that leads kylin returns the wrong results.
Please help me solve it. Thanks!
陈涛
[email protected]
