num_vals()

Get the number of values contained in a uddsketch

Since 1.0.0

Get the number of values contained in a uddsketch. This accessor allows you to calculate a count alongside percentiles, without needing to create two separate aggregates from the same raw data.

Samples

Count the number of integers from 0 to 100.

SELECT num_vals(uddsketch(data))
FROM generate_series(0, 100) data;

num_vals
-----------
    101

Arguments

The syntax is:

num_vals(
  sketch UddSketch
) RETURNS DOUBLE PRECISION

Name	Type	Default	Required	Description
sketch	UddSketch	-	✔	The uddsketch to extract the number of values from

Returns

Column	Type	Description
num_vals	DOUBLE PRECISION	The number of values in the uddsketch.