[jira] [Updated] (KYLIN-3724) Kylin IT test sql is unreasonable

["XiaoXiang Yu (JIRA)" <ji...@apache.org>]

     [ 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-55-13-816.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
>
>
> 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)