Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id E7D52200B73 for ; Mon, 29 Aug 2016 19:36:22 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id E6838160A89; Mon, 29 Aug 2016 17:36:22 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 693EE160AC8 for ; Mon, 29 Aug 2016 19:36:22 +0200 (CEST) Received: (qmail 68785 invoked by uid 500); 29 Aug 2016 17:36:21 -0000 Mailing-List: contact issues-help@spark.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list issues@spark.apache.org Received: (qmail 68736 invoked by uid 99); 29 Aug 2016 17:36:21 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 29 Aug 2016 17:36:21 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 7042C2C0156 for ; Mon, 29 Aug 2016 17:36:21 +0000 (UTC) Date: Mon, 29 Aug 2016 17:36:21 +0000 (UTC) From: "Sean Owen (JIRA)" To: issues@spark.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (SPARK-17298) Require explicit CROSS join for cartesian products MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Mon, 29 Aug 2016 17:36:23 -0000 [ https://issues.apache.org/jira/browse/SPARK-17298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Owen updated SPARK-17298: ------------------------------ Priority: Minor (was: Major) Hm, aren't you suggesting that cartesian joins be _allowed_ when explicitly requested, regardless of the global flag? that's not the same as requiring this syntax, which probably isn't feasible as it would break things. > Require explicit CROSS join for cartesian products > -------------------------------------------------- > > Key: SPARK-17298 > URL: https://issues.apache.org/jira/browse/SPARK-17298 > Project: Spark > Issue Type: Story > Components: SQL > Reporter: Srinath > Priority: Minor > > Require the use of CROSS join syntax in SQL (and a new crossJoin DataFrame API) to specify explicit cartesian products between relations. > By cartesian product we mean a join between relations R and S where there is no join condition involving columns from both R and S. > If a cartesian product is detected in the absence of an explicit CROSS join, an error must be thrown. Turning on the spark.sql.crossJoin.enabled configuration flag will disable this check and allow cartesian products without an explicit cross join. -- 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