[KYLIN-3411] kylin scan different in same sql

• Type: Improvement
• Status: In Progress
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: v2.3.1
• Fix Version/s: Future
• Component/s: Query Engine
• Assignee: Zhong Yanghong
• Reporter: Lemont
• Created: 15/Jun/18 08:42
• Updated: 07/Jan/19 01:57

Description

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