You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Leonid Chistov (Jira)" <ji...@apache.org> on 2022/12/01 14:33:00 UTC

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

Leonid Chistov created CALCITE-5411:
---------------------------------------

             Summary: Update Spark Dialect to support ROLLUP & CUBE aggregate functions.
                 Key: CALCITE-5411
                 URL: https://issues.apache.org/jira/browse/CALCITE-5411
             Project: Calcite
          Issue Type: Task
    Affects Versions: 1.32.0
            Reporter: Leonid Chistov
            Assignee: Leonid Chistov


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.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)