You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2019/03/14 03:49:00 UTC

[jira] [Commented] (CALCITE-2920) RelBuilder: new method to create an antijoin

    [ https://issues.apache.org/jira/browse/CALCITE-2920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16792310#comment-16792310 ] 

Julian Hyde commented on CALCITE-2920:
--------------------------------------

Can you give an example (say using EMP and DEPT) query that uses an anti-join?

> RelBuilder: new method to create an antijoin
> --------------------------------------------
>
>                 Key: CALCITE-2920
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2920
>             Project: Calcite
>          Issue Type: New Feature
>            Reporter: Ruben Quesada Lopez
>            Assignee: Ruben Quesada Lopez
>            Priority: Major
>
> Add new method to RelBuilder in order to create an antijoin.
> Since, for the moment, there is no "AntiJoin" expression, the only possibility to build an AntiJoin is using a LogicalCorrelate with SemiJoinType.ANTI



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)