[CALCITE-3367] Add AntiJoinRule to convert project-filter-join-aggregate into anti-join

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Component/s: core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Jin Xing
• Created: 22/Sep/19 15:49
• Updated: 17/Dec/21 09:05
• Resolved: 26/Sep/19 03:06

Description

This Jira proposes to add AntiJoinRule to convert project-filter-join-aggregate into anti-join.

The idea is from SemiJoinRule.

This issue was found when I resolve CALCITE-3363 in https://github.com/apache/calcite/pull/1466
I failed to construct an anti-join operator from SQL string.

Issue Links

• relates to: CALCITE-3373 Decorrelate boolean context IN or existential subquery directly into SEMI/ANTI join
• links to: GitHub Pull Request #1469