Skip to content

rollup()

Roll up multiple `uddsketch`es

Since 1.0.0

Combine multiple intermediate uddsketch aggregates, produced by uddsketch, into a single intermediate uddsketch aggregate. For example, you can use rollup to combine uddsketches from 15-minute buckets into daily buckets. The input aggregates must have been created with the same size and max_error; a mismatch is not always detected. With different max_error values the estimates are wrong; with different size values the result depends on which aggregate is combined first.

The syntax is:

rollup(
sketch UddSketch
) RETURNS UddSketch
NameTypeDefaultRequiredDescription
sketchUddSketch-✔The uddsketch aggregates to roll up. These must have been created with the same size and max_error
ColumnTypeDescription
rollupUddSketchA new uddsketch aggregate created by combining the input uddsketch aggregates.