You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Furcy Pin (JIRA)" <ji...@apache.org> on 2016/08/29 15:48:20 UTC
[jira] [Created] (SPARK-17296) Spark SQL: cross join + two joins =
BUG
Furcy Pin created SPARK-17296:
---------------------------------
Summary: Spark SQL: cross join + two joins = BUG
Key: SPARK-17296
URL: https://issues.apache.org/jira/browse/SPARK-17296
Project: Spark
Issue Type: Bug
Affects Versions: 2.0.0
Reporter: Furcy Pin
In spark shell :
{code}
CREATE TABLE test (col INT) ;
INSERT OVERWRITE TABLE test VALUES (1), (2) ;
SELECT
COUNT(1)
FROM test T1
CROSS JOIN test T2
JOIN test T3
ON T3.col = T1.col
JOIN test T4
ON T4.col = T1.col
;
{code}
returns :
{code}
Error in query: cannot resolve '`T1.col`' given input columns: [col, col]; line 6 pos 12
{code}
Apparently, this example is minimal (removing the CROSS or one of the JOIN causes no issue).
--
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