[ https://issues.apache.org/jira/browse/CALCITE-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lai Zhou updated CALCITE-3284: ------------------------------ Comment: was deleted (was: [~rubenql], Did Calcite already support semi join/anti join keywords? I intend to query {code:java} SELECT d.deptno, d.name FROM depts d semi join emps e on d.deptno=e.deptno and d.deptno >10{code} but the `semi join` is not supported now. So how to write a case for semi/anti join with nonEquiCondition?) > 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)