diff options
author | xin Wu <xinwu@us.ibm.com> | 2016-05-21 21:41:12 -0700 |
---|---|---|
committer | Wenchen Fan <wenchen@databricks.com> | 2016-05-21 21:41:12 -0700 |
commit | df9adb5ec994f054b2fa58e492867bbc5a60c234 (patch) | |
tree | 7c41d3b5f9314b2002805687b79c9105efde82c6 /sql/hive/src | |
parent | 8f0a3d5bcba313dc3b70d4aa9a8ba2aa2d276062 (diff) | |
download | spark-df9adb5ec994f054b2fa58e492867bbc5a60c234.tar.gz spark-df9adb5ec994f054b2fa58e492867bbc5a60c234.tar.bz2 spark-df9adb5ec994f054b2fa58e492867bbc5a60c234.zip |
[SPARK-15206][SQL] add testcases for distinct aggregate in having clause
## What changes were proposed in this pull request?
Add new test cases for including distinct aggregate in having clause in 2.0 branch.
This is a followup PR for [#12974](https://github.com/apache/spark/pull/12974), which is for 1.6 branch.
Author: xin Wu <xinwu@us.ibm.com>
Closes #12984 from xwu0226/SPARK-15206.
Diffstat (limited to 'sql/hive/src')
-rw-r--r-- | sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/AggregationQuerySuite.scala | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/AggregationQuerySuite.scala b/sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/AggregationQuerySuite.scala index a2bae2e81f..9fc5628b28 100644 --- a/sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/AggregationQuerySuite.scala +++ b/sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/AggregationQuerySuite.scala @@ -958,6 +958,37 @@ abstract class AggregationQuerySuite extends QueryTest with SQLTestUtils with Te Row(11) :: Nil) } } + + test("SPARK-15206: single distinct aggregate function in having clause") { + checkAnswer( + sql( + """ + |select key, count(distinct value1) + |from agg2 group by key + |having count(distinct value1) > 0 + """.stripMargin), + Seq( + Row(null, 3), + Row(1, 2), + Row(2, 2) + ) + ) + } + + test("SPARK-15206: multiple distinct aggregate function in having clause") { + checkAnswer( + sql( + """ + |select key, count(distinct value1), count(distinct value2) + |from agg2 group by key + |having count(distinct value1) > 0 and count(distinct value2) = 3 + """.stripMargin), + Seq( + Row(null, 3, 3), + Row(1, 2, 3) + ) + ) + } } |