into_values()
Get a table of all frequency estimates from a space-saving aggregate
Since 1.16.0
Return the data from a space-saving aggregate as a table. The table lists the stored values with the minimum and maximum bounds for their estimated frequencies.
Arguments
Section titled “Arguments”The syntax is:
into_values( agg SpaceSavingAggregate) RETURNS (AnyElement, DOUBLE PRECISION, DOUBLE PRECISION)| Name | Type | Default | Required | Description |
|---|---|---|---|---|
agg | SpaceSavingAggregate | - | ✔ | A space-saving aggregate created using either freq_agg or mcv_agg |
Returns
Section titled “Returns”| Column | Type | Description |
|---|---|---|
| value | AnyElement | A commonly seen value in the original dataset |
| min_freq | DOUBLE PRECISION | The minimum bound for the estimated frequency |
| max_freq | DOUBLE PRECISION | The maximum bound for the estimated frequency |