Opened 2 years ago

Last modified 2 years 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: master
Severity: Normal Keywords: olap rollup orm
Cc: 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 (1)

comment:1 Changed 2 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.

Note: See TracTickets for help on using tickets.
Back to Top