Partial Partial Aggregates

Claude Brisson · 2026

Read Partial Partial Aggregates by Claude Brisson (2026) in the Tower of Babel, a free online library of public-domain works preserved in clean, searchable text. No sign-up. The full text is served as a plain-text file at a predictable URL, where text is present: https://antarctic-labs.com/tower-of-babel/arxiv-2603-26698.txt.

Description

Brisson introduces partial partial aggregates, a query optimisation trick for distributed engines. Aggregating after a join normally forces two network shuffles, and pushing the full aggregate below the join adds a third. His method pushes only the local compute phase of the aggregate through the join. Data shrinks before the join with no extra shuffle to pay. The trick rests on the distributive property of aggregates. It needs sound estimates of distinct value counts so the optimiser can judge when the push pays off.

Catalog record

CREATORClaude Brisson
YEAR2026
COLLECTIONPAPERS
FORMATTXT
FILE SIZE18728
LICENSEhttp://creativecommons.org/licenses/by/4.0/
RIGHTSCC BY
SOURCEarXiv

Source: https://arxiv.org/abs/2603.26698

Browse the full library · About the Tower of Babel