diff options
author | Andrew Ray <ray.andrew@gmail.com> | 2015-12-08 10:52:17 -0800 |
---|---|---|
committer | Yin Huai <yhuai@databricks.com> | 2015-12-08 10:52:17 -0800 |
commit | 4bcb894948c1b7294d84e2bf58abb1d79e6759c6 (patch) | |
tree | 71dd231854efc677012ae85152b2cea5563b4593 /sql/core | |
parent | 872a2ee281d84f40a786f765bf772cdb06e8c956 (diff) | |
download | spark-4bcb894948c1b7294d84e2bf58abb1d79e6759c6.tar.gz spark-4bcb894948c1b7294d84e2bf58abb1d79e6759c6.tar.bz2 spark-4bcb894948c1b7294d84e2bf58abb1d79e6759c6.zip |
[SPARK-12205][SQL] Pivot fails Analysis when aggregate is UnresolvedFunction
Delays application of ResolvePivot until all aggregates are resolved to prevent problems with UnresolvedFunction and adds unit test
Author: Andrew Ray <ray.andrew@gmail.com>
Closes #10202 from aray/sql-pivot-unresolved-function.
Diffstat (limited to 'sql/core')
-rw-r--r-- | sql/core/src/test/scala/org/apache/spark/sql/DataFramePivotSuite.scala | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/core/src/test/scala/org/apache/spark/sql/DataFramePivotSuite.scala b/sql/core/src/test/scala/org/apache/spark/sql/DataFramePivotSuite.scala index fc53aba68e..bc1a336ea4 100644 --- a/sql/core/src/test/scala/org/apache/spark/sql/DataFramePivotSuite.scala +++ b/sql/core/src/test/scala/org/apache/spark/sql/DataFramePivotSuite.scala @@ -85,4 +85,12 @@ class DataFramePivotSuite extends QueryTest with SharedSQLContext{ sqlContext.conf.setConf(SQLConf.DATAFRAME_PIVOT_MAX_VALUES, SQLConf.DATAFRAME_PIVOT_MAX_VALUES.defaultValue.get) } + + test("pivot with UnresolvedFunction") { + checkAnswer( + courseSales.groupBy("year").pivot("course", Seq("dotNET", "Java")) + .agg("earnings" -> "sum"), + Row(2012, 15000.0, 20000.0) :: Row(2013, 48000.0, 30000.0) :: Nil + ) + } } |