[FLINK-14724] Join condition could be simplified in logical phase

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.9.0, 1.9.1
• Fix Version/s: 1.10.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: godfrey he
• Reporter: godfrey he
• Created: 12/Nov/19 12:38
• Updated: 13/Nov/19 07:21
• Resolved: 13/Nov/19 07:21

Description

currently the plan of tpcds q38.sql contains NestedLoopJoin, because it's join condition is CAST(AND(IS NOT DISTINCT FROM($2, $3), IS NOT DISTINCT FROM($1, $4), IS NOT DISTINCT FROM($0, $5))):BOOLEAN, and planner can't find equal join keys from the condition by Join#analyzeCondition.
SimplifyJoinConditionRule could solve this.

Issue Links

• links to: GitHub Pull Request #10163