"R2 SQL now supports SUM, COUNT, AVG, MIN, and MAX, as well as GROUP BY and HAVING clauses. These aggregation functions let developers run SQL analytics directly on data stored in R2 via the R2 Data Catalog, enabling them to quickly summarize data, spot trends, generate reports, and identify unusual patterns in logs. In addition to aggregations, the update introduces schema discovery commands, including SHOW TABLES and DESCRIBE."
"Whether you are generating reports, monitoring high-volume logs for anomalies, or simply trying to spot trends in your data, you can now easily do it all within Cloudflare's Developer Platform without the overhead of managing complex OLAP infrastructure or moving data out of R2."
"Cloudflare continues to push data closer to the edge with aggregation support in R2 SQL, expanding the kinds of workloads developers can realistically run there."
R2 SQL adds aggregation capabilities and schema discovery to enable analytics directly over data stored in R2. Supported functions include SUM, COUNT, AVG, MIN, and MAX alongside GROUP BY and HAVING. Schema discovery commands such as SHOW TABLES and DESCRIBE simplify exploration of datasets in the R2 Data Catalog. Developers can summarize data, spot trends, generate reports, and detect anomalies in logs without moving data or managing separate OLAP infrastructure. Distributed GROUP BY execution uses scatter-gather and shuffling strategies with a coordinator node that consults the R2 Data Catalog to locate relevant Parquet row groups for query execution.
Read at InfoQ
Unable to calculate read time
Collection
[
|
...
]