You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Xiao Li (JIRA)" <ji...@apache.org> on 2016/10/08 20:07:20 UTC

[jira] [Commented] (SPARK-10933) Spark SQL Joins should have option to fail query when row multiplication is encountered

    [ https://issues.apache.org/jira/browse/SPARK-10933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15558625#comment-15558625 ] 

Xiao Li commented on SPARK-10933:
---------------------------------

Now, we have a conf `spark.sql.crossJoin.enabled`. 

Let me close it now. If you still think we need extra conf, please reopen it. Thanks!

> Spark SQL Joins should have option to fail query when row multiplication is encountered
> ---------------------------------------------------------------------------------------
>
>                 Key: SPARK-10933
>                 URL: https://issues.apache.org/jira/browse/SPARK-10933
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Stephen Link
>            Priority: Minor
>
> When constructing spark sql queries, we commonly run into scenarios where users have inadvertently caused a cartesian product/row expansion. It is sometimes possible to detect this in advance with separate queries, but it would be far more ideal if it was possible to have a setting that disallowed join keys showing up multiple times on both sides of a join operation.
> This setting would belong in SQLConf. The functionality could likely be implemented by forcing a sorted shuffle, then checking for duplication on the streamed results.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

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