[
https://issues.apache.org/jira/browse/KYLIN-3674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
chenchen updated KYLIN-3674:
----------------------------
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
was:
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
> 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,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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
