min_val()

min_val(digest TDigest) RETURNS DOUBLE PRECISION

Get the minimum value from a t-digest (does not work with percentile_agg or uddsketch based estimators). This is provided in order to save space when both a minimum and a percentile estimate are required as part of continuous aggregates. You can simply compute a single percentile estimator and do not need to specify a separate min aggregate, just extract the min_val from the percentile estimator.

Required Arguments

Returns

Sample Usages

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

min_val
-----------
         1