[
https://issues.apache.org/jira/browse/CALCITE-3367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17461296#comment-17461296
]
Khawla Mouhoubi commented on CALCITE-3367:
------------------------------------------
[[email protected]] , I also found the necessity of implementing a rule like
this in my project, so I did my own version (quite similar to your original PR).
I would like to re-open this ticket, and create a PR to push this rule into
Calcite. I think probably some more Calcite users would benefit from it, since
as of today, the Sql to Rel conversion does not produce a proper antiJoin (but
a LeftJoin + Aggregate), so the only possibility that we have to get an
antiJoin is via a rule (similarly to semiJoin and SemiJoinRule).
> Add AntiJoinRule to convert project-filter-join-aggregate into anti-join
> ------------------------------------------------------------------------
>
> Key: CALCITE-3367
> URL: https://issues.apache.org/jira/browse/CALCITE-3367
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Jin Xing
> Priority: Major
> Labels: pull-request-available
> Time Spent: 3h 10m
> Remaining Estimate: 0h
>
> 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.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
