[jira] [Created] (SPARK-27096) Reconcile the join type support between data frame and sql interface

["Dilip Biswal (JIRA)" <ji...@apache.org>]

Dilip Biswal created SPARK-27096:
------------------------------------

             Summary: Reconcile the join type support between data frame and sql interface
                 Key: SPARK-27096
                 URL: https://issues.apache.org/jira/browse/SPARK-27096
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 2.4.0
            Reporter: Dilip Biswal


Currently in the grammar file, we have the joinType rule defined as following :
{code:java}
joinType
 : INNER?
 ....
 ....
 | LEFT SEMI
 | LEFT? ANTI
 ;
{code:java}
 {code}
The keyword LEFT is optional for ANTI join even though its not optional for SEMI join. When
 using data frame interface join type "anti" is not allowed. The allowed types are "left_anti" or 
 "leftanti" for anti joins. We should also make LEFT optional for SEMI join and allow "semi" and "anti" join types from data frame.

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org