Skip to content
Join us at Tiger Data Aggregate 2026 for workshops, talks, and networking.

rollup()

Roll up multiple hyperloglogs

Since 1.3.0

Combine multiple intermediate hyperloglog aggregates, produced by hyperloglog, into a single intermediate hyperloglog aggregate. For example, you can use rollup to combine hyperloglog from 15-minute buckets into daily buckets.

The syntax is:

rollup(
hyperloglog Hyperloglog
) RETURNS Hyperloglog
NameTypeDefaultRequiredDescription
hyperloglogHyperloglog-The hyperloglog aggregates to roll up.
ColumnTypeDescription
rollupHyperloglogA new hyperloglog aggregate created by combining the input hyperloglog aggregates.