这个关于【WITH ROLLUP】的issues还有实现的希望么？【催更】

Kongdom · 2021 年11 月 15 日 03:42

如题，急需with rollup功能~:sunglasses:

TiDB 目前不支持 GROUP BY 修饰符，例如 WITH ROLLUP ，将来会提供支持。详情参阅 #4250。

github.com/pingcap/tidb

support `GROUP BY` modifiers

已打开 12:58PM - 19 Aug 17 UTC

zz-jason

help wanted sig/execution type/feature-request feature/accepted

## Request Description MySQL and Oracle support [`ROLLUP`](https://dev.mysql.…com/doc/refman/5.7/en/group-by-modifiers.html) modifier, SQL Server also supports `CUBE` and `GROUPING SETS` References: - MySQL: [GROUP BY Modifiers](https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html) - Oracle Database: - [ROLLUP Extension to GROUP BY](https://docs.oracle.com/en/database/oracle/oracle-database/20/dwhsg/sql-aggregation-data-warehouses.html#GUID-01BBD582-E149-47D7-A4F8-F50C1AAC66AA) - [CUBE Extension to GROUP BY](https://docs.oracle.com/en/database/oracle/oracle-database/20/dwhsg/sql-aggregation-data-warehouses.html#GUID-C5FDD050-DCE0-4FE1-9741-420E2F970A36) - [GROUPING Functions](https://docs.oracle.com/en/database/oracle/oracle-database/20/dwhsg/sql-aggregation-data-warehouses.html#GUID-E4251C0F-8AD7-4826-BE35-845E5CE6C818) - [GROUPING SETS Expression](https://docs.oracle.com/en/database/oracle/oracle-database/20/dwhsg/sql-aggregation-data-warehouses.html#GUID-166E1BFC-51C6-4BB5-B10B-A8EB63472E49) - SQL Server: [SELECT - GROUP BY](https://docs.microsoft.com/en-us/sql/t-sql/queries/select-group-by-transact-sql?view=sql-server-ver15) An example in MySQL: ```sql drop table if exists t; create table t(a bigint, b bigint, c bigint); insert into t values(1, 2, 3), (2, 2, 3), (3, 2, 3); ``` ```sql MySQL > select a, min(b) from t group by a with rollup; +------+--------+ | a | min(b) | +------+--------+ | 1 | 2 | | 2 | 2 | | 3 | 2 | | NULL | 2 | +------+--------+ 4 rows in set (0.01 sec) ``` ## Category Feature ## Value - Value Point: 2 It's hard to tell the value for now. Quoted from https://docs.oracle.com/cd/F49540_01/DOC/server.815/a68003/rollup_c.htm: > One of the key concepts in decision support systems is "multi-dimensional analysis": examining the enterprise from all necessary combinations of dimensions. We use the term "dimension" to mean any category used in specifying questions. Among the most commonly specified dimensions are time, geography, product, department, and distribution channel, but the potential dimensions are as endless as the varieties of enterprise activity. The events or entities associated with a particular set of dimension values are usually referred to as "facts." The facts may be sales in units or local currency, profits, customer counts, production volumes, or anything else worth tracking. I think the value of this request is to improve the usability and performance in Business Intelligence(BI) scenarios. No need to run several aggregate queries to get another level aggregate result. I'm curious about whether are some BI tools rely on this feature. ### Workload Estimation > Workload contains coding, documenting, and testing. > 1 Point for 1 Person/Work Day - 60 Points, hard to say, most modifications are on the aggregate operator in execution engine.

Billmay表妹 · 2021 年11 月 15 日 03:49

我问问~

Kongdom · 2021 年11 月 15 日 03:50

Billmay表妹 · 2021 年11 月 16 日 02:51

问了一下产品的 PM ~回复是：目前没有排期做这个~

Kongdom · 2021 年11 月 16 日 03:27

这是一个项目和程序员比命长的需求~

Billmay表妹 · 2021 年11 月 16 日 03:55

内心哭泣~

db_user · 2021 年11 月 16 日 06:09

需要祭天一个程序员了，我们目前是开发改代码来弄的

Billmay表妹 · 2021 年11 月 16 日 06:13

kongdom 要改的话只能自己改 hhhhh

Kongdom · 2021 年11 月 16 日 06:21

已经动手改造自己的系统了，在程序上添加合计行

Hacker_nQUBzGNk · 2022 年1 月 20 日 11:40

什么时候能支持啊？有没有计划？急需

Kongdom · 2022 年10 月 31 日 19:16

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。