I meet 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;
And i get the uncorrect results:
But when i change the sql like this：
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;
Then i get the correct results:
I want to know why kylin only returned 2 records when the query term is “CITY
IN ('武汉')”. It should returned 4 records。
陈涛
[email protected]
