[ https://issues.apache.org/jira/browse/CALCITE-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16915539#comment-16915539 ]
Ruben Quesada Lopez commented on CALCITE-3284: ---------------------------------------------- [~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)