[jira] [Commented] (CALCITE-3367) Add AntiJoinRule to convert project-filter-join-aggregate into anti-join

["Khawla Mouhoubi (Jira)" <ji...@apache.org>]

    [ 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:
------------------------------------------

[~jinxing6042@126.com] , 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)