[
https://issues.apache.org/jira/browse/CALCITE-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16915539#comment-16915539
]
Ruben Quesada Lopez edited comment on CALCITE-3284 at 8/26/19 7:39 AM:
-----------------------------------------------------------------------
[~hhlai1990], you can create the test using RelBuilder (see
{{EnumerableJoinTest#equiAntiJoin}}, {{EnumerableJoinTest#nonEquiAntiJoin}}).
Unfortunately, I think it is not possible to create tests in SQL, since the SQL
parser does not generate joins with type SEMI/ANTI for the moment.
was (Author: rubenql):
[~hhlai1990], you can create the test using RelBuilder (see
{{EnumerableJoinTest#equiAntiJoin}}, {{EnumerableJoinTest#nonEquiAntiJoin}}).
Unfortunately, I think it is not possible to create tests in SQL, since the SQL
parse does not generate joins with type SEMI/ANTI for the moment.
> Enumerable hash semijoin / antijoin support non-equi join conditions
> --------------------------------------------------------------------
>
> Key: CALCITE-3284
> URL: https://issues.apache.org/jira/browse/CALCITE-3284
> Project: Calcite
> Issue Type: Improvement
> Reporter: Haisheng Yuan
> Priority: Major
>
> Calcite should be able to generate enumerable hash semijoin / antijoin with
> non-equi join conditions, as long as there are equi-join condtions, so that
> we can do hash look up.
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
