min_frequency()

Get the minimum bound of the estimated frequency for a given value in a space-saving aggregate

Since 1.16.0

Get the minimum bound of the estimated frequency for a given value in a space-saving aggregate.

Samples

Find the minimum frequency of the value 3 in a column named value within the table value_test:

SELECT min_frequency(
    (SELECT mcv_agg(20, value) FROM value_test),
    3
);

Arguments

The syntax is:

min_frequency (
    agg SpaceSavingAggregate,
    value AnyElement
) RETURNS DOUBLE PRECISION

Name	Type	Default	Required	Description
agg	SpaceSavingAggregate	-	✔	A space-saving aggregate created using either freq_agg or mcv_agg
value	AnyElement	-	✔	The value to get the frequency of

Returns

Column	Type	Description
min_frequency	DOUBLE PRECISION	The minimum bound for the value’s estimated frequency. The minimum frequency might be 0 if the value’s frequency falls below the space-saving aggregate’s cut-off threshold. For more information, see freq_agg.