kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lemont (JIRA)" <>
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
             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


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

View raw message