Opened 4 years ago

Last modified 5 days 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: Adam (Chainz) Johnson, Hannes Ljungberg 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 (3)

comment:1 Changed 4 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 4 months ago by Adam (Chainz) Johnson

Cc: Adam (Chainz) Johnson added

comment:3 Changed 5 days ago by Hannes Ljungberg

Cc: Hannes Ljungberg added
Note: See TracTickets for help on using tickets.
Back to Top