You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Lemont (JIRA)" <ji...@apache.org> on 2018/06/15 09:56:00 UTC
[jira] [Updated] (KYLIN-3411) kylin scan different in same sql
[ https://issues.apache.org/jira/browse/KYLIN-3411?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lemont updated KYLIN-3411:
--------------------------
Priority: Blocker (was: Major)
> 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
> Priority: Blocker
>
> 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)