[ 
https://issues.apache.org/jira/browse/KYLIN-3674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

chenchen updated KYLIN-3674:
----------------------------
    Affects Version/s: v2.5.1
        Fix Version/s:     (was: v2.5.1)

> count distinct > count(*)/sum(1)
> --------------------------------
>
>                 Key: KYLIN-3674
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3674
>             Project: Kylin
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: v2.5.1
>            Reporter: chenchen
>            Priority: Major
>
> 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)

Reply via email to