[FLINK-12509] Introduce planner rules about non semi/anti join

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Implemented
• Fix Version/s: 1.9.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: godfrey he
• Reporter: godfrey he
• Created: 14/May/19 13:06
• Updated: 22/May/19 01:15
• Resolved: 22/May/19 01:15

Description

This issue aims to introduce planner rules about non semi/anti join, rules include:
1. JoinConditionEqualityTransferRule, that converts Join's conditions to the left or right table's own independent filter as much as possible, so that the rules of filter-push-down can push down the filter to below.
2. JoinConditionTypeCoerceRule, that coerces the both sides of EQUALS(`=`) operator in Join condition to the same type while sans nullability.
3. JoinDependentConditionPushDownRule, that extracts some sub-conditions in the Join OR condition that can be pushed into join inputs by FlinkFilterJoinRule.
4. JoinDeriveNullFilterRule filters null values before join if the count null value from join input
is greater than sql.optimizer.join.null.filter.threshold
5. SimplifyJoinConditionRule, that apply various simplifying transformations on join condition.

planner rules about semi/anti join will be introduced in FLINK-12519.

Issue Links

• is a child of: FLINK-11488 Add a basic Blink planner framework
• links to: GitHub Pull Request #8440