min_val()

min_val(digest TDigest) RETURNS DOUBLE PRECISION

Get the minimum value from a tdigest. This does not work with percentile_agg or uddsketch based estimators. This saves space when you require both a minimum and a percentile estimate as part of a continuous aggregate. You can compute a single percentile estimator and do not need to specify a separate min aggregate, by extracting the min_val from the percentile estimator.

Required arguments

NameTypeDescription
digestTDigestThe digest to extract the min value from

Returns

ColumnTypeDescription
min_valDOUBLE PRECISIONThe minimum value entered into the t-digest

Sample usage

SELECT min_val(tdigest(100, data))
FROM generate_series(1, 100) data;
min_val
-----------
         1

Found an issue on this page?

Report an issue!

Related Content