[CALCITE-6031] Add the planner rule that pushes the Filter past a Sample

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.36.0
• Component/s: core
• Labels: pull-request-available
• Assignee: LakeShen
• Reporter: LakeShen
• Created: 30/Sep/23 14:09
• Updated: 10/Nov/23 11:34
• Resolved: 10/Oct/23 13:02

Description

The Filter could be pushed past the Sample.

For example:

select deptno from "scott".dept tablesample system(50) where  deptno > 10

The plan tree is :

 LogicalProject(o_orderkey=[$0])
  LogicalFilter(condition=[>($0, 0)])
    Sample(mode=[system], rate=[0.5], repeatableSeed=[-])
      LogicalTableScan(table=[[tpch, ORDERS]]) 

Could be rewrite to :

  LogicalProject(o_orderkey=[$0])
    Sample(mode=[system], rate=[0.5], repeatableSeed=[-])
      LogicalFilter(condition=[>($0, 0)])      
        LogicalTableScan(table=[[tpch, ORDERS]]) 

The same logic could see Presto/Trino: PredicatePushDown.Rewriter#visitSample

Issue Links

• links to: GitHub Pull Request #3453