Announcing support for GROUP BY, SUM, and other aggregation queries in R2 SQL

Cloudflare announces support for aggregations in R2 SQL, detailing how scatter-gather and shuffle-based distributed execution enable efficient GROUP BY queries with HAVING, ORDER BY, and LIMIT on massive datasets stored in R2 Data Catalog. By hashing and colocating group keys, enforcing a synchronization barrier, and performing a coordinator k-way merge of pre-sorted results, R2 SQL scales analytics workloads for reporting, anomaly detection, and trend analysis without overloading a single node.