kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shaofeng SHI (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (KYLIN-3411) kylin scan different in same sql
Date Fri, 14 Sep 2018 01:45:00 GMT

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

Shaofeng SHI updated KYLIN-3411:
--------------------------------
         Priority: Minor  (was: Blocker)
    Fix Version/s: v2.6.0
       Issue Type: Bug  (was: Improvement)

> kylin scan different in same sql
> --------------------------------
>
>                 Key: KYLIN-3411
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3411
>             Project: Kylin
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: v2.3.1
>            Reporter: Lemont
>            Priority: Minor
>             Fix For: v2.6.0
>
>
> There are two sql:
> select sum(value) from test where time > 1524326400 group by id
> and
> select sum(value) from test where time > (1524931200-7*86400) group by id
> As we can see 1524326400 =(1524931200-7*86400) 
> but the second sql query slower than the first sql
> Cuboid Ids: [3904]
> Total scan count: 1157959
> Total scan bytes: 265530668
> Result row count: 34991
> Cuboid Ids: [3904]
> Total scan count: 611795
> Total scan bytes: 140681855
> Result row count: 34991



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message