Opened 6 years ago

Last modified 8 weeks 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 Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no


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.

Change History (4)

comment:1 Changed 6 years ago by Tim Graham

Summary: Group by modifiers, OLAP functionalityAdd QuerySet support for group by modifiers and OLAP functionality
Triage Stage: UnreviewedAccepted

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.

comment:2 Changed 3 years ago by Adam Johnson

Cc: Adam Johnson added

comment:3 Changed 2 years ago by Hannes Ljungberg

Cc: Hannes Ljungberg added

comment:4 Changed 8 weeks ago by John Speno

Cc: John Speno added
Note: See TracTickets for help on using tickets.
Back to Top