You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@kylin.apache.org by "Lemont (JIRA)" <ji...@apache.org> on 2018/06/15 08:43:00 UTC

[jira] [Created] (KYLIN-3411) kylin scan different in same sql

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)