[
https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759982#comment-17759982
]
LakeShen commented on CALCITE-5962:
-----------------------------------
Thank you for opening this PR, I left a couple of comments!
> Allow Spark-style syntax "LEFT ANTI JOIN" in Babel parser
> ---------------------------------------------------------
>
> Key: CALCITE-5962
> URL: https://issues.apache.org/jira/browse/CALCITE-5962
> Project: Calcite
> Issue Type: Wish
> Reporter: LiYuE
> Assignee: Mingcan Wang
> Priority: Major
> Labels: pull-request-available
> 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)
