[
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)
