kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lemont (JIRA)" <j...@apache.org>
Subject [jira] [Created] (KYLIN-3411) kylin scan different in same sql
Date Fri, 15 Jun 2018 08:43:00 GMT
Lemont created KYLIN-3411:
-----------------------------

             Summary: kylin scan different in same sql
                 Key: KYLIN-3411
                 URL: https://issues.apache.org/jira/browse/KYLIN-3411
             Project: Kylin
          Issue Type: Improvement
          Components: Query Engine
    Affects Versions: v2.3.1
            Reporter: Lemont


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