[
https://issues.apache.org/jira/browse/SPARK-13105?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15125199#comment-15125199
]
Apache Spark commented on SPARK-13105:
--------------------------------------
User 'JoshRosen' has created a pull request for this issue:
https://github.com/apache/spark/pull/10997
> Spark 1.6 and earlier should reject NATURAL JOIN queries instead of returning
> wrong answers
> -------------------------------------------------------------------------------------------
>
> Key: SPARK-13105
> URL: https://issues.apache.org/jira/browse/SPARK-13105
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.4.1, 1.5.2, 1.6.0
> Reporter: Josh Rosen
> Assignee: Josh Rosen
>
> In Spark 1.6 and earlier, Spark SQL does not support {{NATURAL JOIN}}
> queries. However, its SQL parser does not consider {{NATURAL}} to be a
> reserved word, which causes natural joins to be parsed as regular joins where
> the left table has been aliased. For instance,
> {code}
> SELECT * FROM foo NATURAL JOIN bar
> {code}
> gets interpreted as "foo JOIN bar" where "foo" is aliased to "natural".
> Rather than doing this, which leads to confusing / wrong results for users
> who expect NATURAL JOIN behavior, Spark should immediately reject these
> queries at analysis time and should provide an informative error message.
> We're going to add natural join support in Spark 2.0, but for earlier
> versions we should add a bugfix to throw errors.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
