[CALCITE-3834] Support AntiJoin in EnumerableMergeJoin

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.21.0
• Fix Version/s: 1.24.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Ruben Q L
• Reporter: Ruben Q L
• Created: 27/Feb/20 09:19
• Updated: 25/Jul/20 14:59
• Resolved: 08/Jul/20 15:24

Description

Currently, EnumerableMergeJoin only supports INNER & SEMI joins. The goal of this ticket is to improve this join operator in order to support ANTI joins too.

Note: RelMdCollation#mergeJoin will need to be modified too: in case of ANTI join, it must return just the leftCollations. UPDATE: this has been done already as part of CALCITE-3833.

Issue Links

• is blocked by: CALCITE-3285 EnumerableMergeJoin should support non-equi join conditions
• relates to: CALCITE-3833 Support SemiJoin in EnumerableMergeJoin
• relates to: CALCITE-4113 Support LEFT join in EnumerableMergeJoin
• links to: GitHub Pull Request #2037
• links to: PR#2037