chenchen created KYLIN-3674:
-------------------------------
Summary: count distinct > count(*)/sum(1)
Key: KYLIN-3674
URL: https://issues.apache.org/jira/browse/KYLIN-3674
Project: Kylin
Issue Type: Bug
Reporter: chenchen
select dc,plf,sckw,sc,count(*) 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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
