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