[CALCITE-5411] Update Spark Dialect to support ROLLUP & CUBE aggregate functions.

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.32.0
• Fix Version/s: 1.35.0
• Labels: pull-request-available
• Assignee: Leonid Chistov
• Reporter: Leonid Chistov
• Created: 01/Dec/22 14:32
• Updated: 27/Jul/23 10:22
• Resolved: 27/Mar/23 04:49

Description

Support for standard

GROUP BY { group_expression |
{ ROLLUP | CUBE | GROUPING SETS }
(grouping_set [ , ...]) } [ , ... ] 

 syntax was added to Spark several releases ago in addition to the previously supported non-standard syntax 

GROUP BY group_expression [ , group_expression [ , ... ] ] [ WITH { ROLLUP | CUBE } ] 

See: https://spark.apache.org/docs/latest/sql-ref-syntax-qry-select-groupby.html

We need to update SparkSqlDialect implementation to reflect these changes in supported SQL syntax.

Issue Links

• relates to: CALCITE-3077 Rewrite CUBE&ROLLUP queries in SparkSqlDialect
• links to: GitHub Pull Request #2994
• links to: GitHub Pull Request #2994