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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org