[ https://issues.apache.org/jira/browse/CALCITE-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16915531#comment-16915531 ]
Lai Zhou commented on CALCITE-3284: ----------------------------------- [~rubenql], Since Calcite can't support `semi join` or `anti join` keywords now, so how to construct a sql to test a semi join with nonEquiConditions? And a anti join with nonEquiConditions?  > 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)