[
https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759555#comment-17759555
]
LakeShen commented on CALCITE-5962:
-----------------------------------
I found that in the JoinType class, there is already a LEFT_SEMI_JOIN JoinType,
but it is not used in Calcite, only in Babel's Hive dialect.
Maybe we could add the `Anti Join` JoinType,it is not used in Calcite, only in
Babel's Spark dialect.
!image-2023-08-28-19-47-40-712.png|width=785,height=202!
> Add "ANTI" enumeration join type at JoinType.java
> -------------------------------------------------
>
> Key: CALCITE-5962
> URL: https://issues.apache.org/jira/browse/CALCITE-5962
> Project: Calcite
> Issue Type: Wish
> Reporter: LiYuE
> Priority: Major
> Attachments: image-2023-08-28-19-47-40-712.png
>
>
> Currently, Spark SQL supports parsing the "anti join" SQL syntax [Spark anti
> join|https://spark.apache.org/docs/3.4.1/sql-ref-syntax-qry-select-join.html#anti-join],
> but the
> org.apache.calcite.sql.JoinType.java in Calcite does not include this
> enumeration. Therefore, it is hoped that Calcite can add an enumeration type
> for anti join to be compatible with the Spark syntax.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
