[
https://issues.apache.org/jira/browse/SPARK-41635?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17675526#comment-17675526
]
Apache Spark commented on SPARK-41635:
--------------------------------------
User 'cloud-fan' has created a pull request for this issue:
https://github.com/apache/spark/pull/39509
> GROUP BY ALL
> ------------
>
> Key: SPARK-41635
> URL: https://issues.apache.org/jira/browse/SPARK-41635
> Project: Spark
> Issue Type: New Feature
> Components: SQL
> Affects Versions: 3.3.0
> Reporter: Reynold Xin
> Assignee: Reynold Xin
> Priority: Major
> Fix For: 3.4.0
>
>
> This patch implements GROUP BY ALL, similar to the one initially implemented
> in DuckDB. When specified, the analyzer automatically infers the grouping
> columns based on the expressions specified in the select clause: all
> expressions that don't include any aggregate expressions are pulled
> implicitly into the grouping columns. This avoids users having to specify
> individually the list of grouping columns in most cases.
> Examples:
> {noformat}
> select key, count, sum(score) from table group by all
> -- rewritten to
> select key, count, sum(score) from table group by key{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
