[
https://issues.apache.org/jira/browse/SPARK-6376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael Armbrust updated SPARK-6376:
------------------------------------
Summary: Subqueries are thrown away too early in dataframes (was: Relation
are thrown away too early in dataframes)
> Subqueries are thrown away too early in dataframes
> --------------------------------------------------
>
> Key: SPARK-6376
> URL: https://issues.apache.org/jira/browse/SPARK-6376
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Reporter: Michael Armbrust
> Priority: Critical
>
> Because we throw away aliases as we construct the query plan, you can't
> reference them later. For example, this query fails:
> {code}
> test("self join with aliases") {
> val df = Seq(1,2,3).map(i => (i, i.toString)).toDF("int", "str")
> checkAnswer(
> df.as('x).join(df.as('y), $"x.str" ===
> $"y.str").groupBy("x.str").count(),
> Row("1", 1) :: Row("2", 1) :: Row("3", 1) :: Nil)
> }
> {code}
> {code}
> [info] org.apache.spark.sql.AnalysisException: Cannot resolve column name
> "x.str" among (int, str, int, str);
> [info] at
> org.apache.spark.sql.DataFrame$$anonfun$resolve$1.apply(DataFrame.scala:162)
> [info] at
> org.apache.spark.sql.DataFrame$$anonfun$resolve$1.apply(DataFrame.scala:162)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
