Opened 7 years ago
Last modified 10 months ago
#27646 new New feature
Add QuerySet support for group by modifiers and OLAP functionality
| Reported by: | Mads Jensen | Owned by: | nobody |
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | dev |
| Severity: | Normal | Keywords: | olap rollup orm |
| Cc: | Adam Johnson, Hannes Ljungberg, John Speno, David Sanders | Triage Stage: | Accepted |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
PostgreSQL 9.5 introduced cube, grouping sets and rollup. MySQL/MariaDB supports the rollup-operation for aggregations. Oracle (obviously) also supports rollup, grouping sets and cube. I suggest adding methods in QuerySet for this, feature-flags to indicate level of support, and either new expressions for the different rollup-syntax, or amend the operations of the backends for this. The syntax is slightly different in MySQL/MariaDB, as it uses WITH ROLLUP, rather than ROLLUP.
https://oracle-base.com/articles/misc/rollup-cube-grouping-functions-and-grouping-sets
http://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html
https://www.postgresql.org/docs/current/static/queries-table-expressions.html#QUERIES-GROUPING-SETS
Change History (5)
comment:1 by , 7 years ago
| Summary: | Group by modifiers, OLAP functionality → Add QuerySet support for group by modifiers and OLAP functionality |
|---|---|
| Triage Stage: | Unreviewed → Accepted |
comment:2 by , 4 years ago
| Cc: | added |
|---|
comment:3 by , 4 years ago
| Cc: | added |
|---|
comment:4 by , 21 months ago
| Cc: | added |
|---|
comment:5 by , 10 months ago
| Cc: | added |
|---|
Tentatively accepting. It might be nice to elaborate on the details such as by writing documentation and getting feedback on that before starting to code.