kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "chenchen (JIRA)" <j...@apache.org>
Subject [jira] [Created] (KYLIN-3674) count distinct > count(*)/sum(1)
Date Thu, 08 Nov 2018 08:26:00 GMT
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)

Mime
View raw message