GitHub user dilipbiswal opened a pull request:
https://github.com/apache/spark/pull/21813
[SPARK 24424] Support ANSI-SQL compliant syntax for GROUPING SET
## What changes were proposed in this pull request?
Enhances the parser and analyzer to support ANSI compliant syntax for
GROUPING SET. As part of this change we derive the grouping expressions from
user supplied groupings in the grouping sets clause.
```SQL
SELECT c1, c2, max(c3)
FROM t1
GROUP BY GROUPING SETS ((c1), (c1, c2))
```
## How was this patch tested?
Added tests in SQLQueryTestSuite and ResolveGroupingAnalyticsSuite.
Please review http://spark.apache.org/contributing.html before opening a
pull request.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/dilipbiswal/spark spark-24424
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/spark/pull/21813.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #21813
----
commit b5ada3feb7d243859714c04ec4fb8c225c1781e0
Author: Dilip Biswal <dbiswal@...>
Date: 2018-07-19T05:12:33Z
[SPARK-24424] Support ANSI-SQL compliant syntax for GROUPING SET
----
---
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org
