[ https://issues.apache.org/jira/browse/KYLIN-3724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
XiaoXiang Yu updated KYLIN-3724: -------------------------------- Attachment: image-2018-12-17-16-58-00-559.png > Kylin IT test sql is unreasonable > --------------------------------- > > Key: KYLIN-3724 > URL: https://issues.apache.org/jira/browse/KYLIN-3724 > Project: Kylin > Issue Type: Bug > Reporter: XiaoXiang Yu > Assignee: XiaoXiang Yu > Priority: Major > Attachments: image-2018-12-17-16-55-13-816.png, > image-2018-12-17-16-58-00-559.png, image-2018-12-17-16-58-28-349.png > > > In kylin-it, we use query under sql_distinct_precisely folder to test the > COUNT_DISTINCT(Bitmap) . But we find that query04 using a COUNT_DISTINCT(HLL) > as having condition, it is unreasonable. > > {quote}select test_cal_dt.cal_dt,sum(test_kylin_fact.price) as GMV > , count(1) as TRANS_CNT > , count(distinct TEST_COUNT_DISTINCT_BITMAP) as user_count > , count(distinct site_name) as site_count > from test_kylin_fact > inner JOIN edw.test_cal_dt as test_cal_dt > ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt > inner JOIN test_category_groupings > on test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id and > test_kylin_fact.lstg_site_id = test_category_groupings.site_id > inner JOIN edw.test_sites as test_sites > on test_kylin_fact.lstg_site_id = test_sites.site_id > inner JOIN edw.test_seller_type_dim as test_seller_type_dim > on test_kylin_fact.slr_segment_cd = test_seller_type_dim.seller_type_cd > where test_kylin_fact.lstg_format_name='FP-GTC' > and test_cal_dt.cal_dt between DATE '2013-05-01' and DATE '2013-08-01' > group by test_cal_dt.cal_dt > having count(distinct seller_id) > 2 > {quote} > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)