[KYLIN-4287] SegmentPruner cannot prune segment with "IN" or "OR" CompareTupleFilter

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v3.1.0, v3.0.1
• Component/s: Query Engine
• Assignee: yangzhang
• Reporter: yangzhang
• Created: 10/Dec/19 09:13
• Updated: 31/Jul/20 12:18
• Resolved: 15/Dec/19 07:10

Description

build 2 segs, Segment[2012-01-01 - 2012-01-03]  And Segment[2012-01-03 - 2012-01-05]

query: select sum(PRICE) from KYLIN_SALES
where "KYLIN_SALES"."PART_DT" = DATE '2012-01-01'
OR "KYLIN_SALES"."PART_DT" = DATE '2020-07-02'

Expected results:segment[2012-01-03 - 2012-01-05] should not be scaned, it should be pruned by SegmentPruner

 

but i found in method 'org.apache.kylin.cube.common.SegmentPruner#satisfy'

when filter's operator is "In", satisfy segment[2012-01-03 - 2012-01-05] , the function return true

 

Issue Links

• links to: GitHub Pull Request #984