[KYLIN-3674] count distinct > count(*)/sum(1)

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: v2.5.1
• Component/s: Query Engine
• Assignee: Unassigned
• Reporter: chenchen
• Created: 08/Nov/18 08:25
• Updated: 08/Nov/18 08:32

Description

select dc,plf,sckw,sc,sum (1) search_pv,count(distinct oi) search_uv,sckw_last_nums from es_gearbest_10002.STAT_SEARCH_DATA_TABLE_VIEW wt where t = 'ic' and x = 'search' and date_id = '2018-11-02' and sckw != '[]' and sckw != 'nill' and dc = '1301'
group by dc,plf,sckw,sc,sckw_last_nums
having search_uv> search_pv
 
I run this sql,but have many(2000 more) result that search_uv > search_pv in version2.5.1.
and I convert version to 2.4.1 then don't have any result.
 
version 2.5.1 is more fast than 2.4.1.
I need your help