[
https://issues.apache.org/jira/browse/CALCITE-2920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16792878#comment-16792878
]
Julian Hyde commented on CALCITE-2920:
--------------------------------------
Thanks. That helps a lot.
In the relational algebra, it seems to me that anti-joins are so similar to
semi-joins that we should use the same structure (i.e. {{SemiJoin}} with a
{{boolean anti}} flag, and {{SemiJoinFactory}}). But we could still add an
{{antiJoin}} method to {{RelBuilder}}.
> 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)