[FLINK-12487] Introduce planner rules to rewrite expression and merge calc

• 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: 10/May/19 12:05
• Updated: 13/May/19 01:25
• Resolved: 13/May/19 01:25

Description

This issue aims to introduce planner rules to rewrite expression and merge calc, rules include:
1. ConvertToNotInOrInRule, that converts a cascade of predicates to IN or NOT_IN,
e.g.
converts predicate (x = 1 OR x = 2 OR x = 3 OR x = 4) AND y = 5 to predicate x IN (1, 2, 3, 4) AND y = 5
converts predicate (x <> 1 AND x <> 2 AND x <> 3 AND x <> 4) AND y = 5 to predicate x NOT IN (1, 2, 3, 4) AND y = 5
2. RewriteCoalesceRule, that rewrites Coalesce to Case When
3. FlinkCalcMergeRule, that is copied from Calcite CalcMergeRule, and it will simplify the merged program

Issue Links

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