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