arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

percentilekllmv

This section contains reference documentation for the PERCENTILEKLLMV function.

Variant of the PERCENTILEKLL aggregation function which accepts multi-value columns. Values in the given column are 'flattened' before aggregation, so the function will produce a single value for the given percentile.

hashtag
Signature

PercentileKLLMV(column, percentile, kValue) -> Double

  • column (required): Name of the column to aggregate on.

  • percentile (required): Percentile value to be calculated [0..100]

  • kValue: Integer value which determines the size of the sketch. Default value is

hashtag
Usage Examples

value
200
which corresponds to a normalized rank error of about 1.65%. For details, see the
.
select percentileKLLMV(ArrOfInts, 90) as value
from MyTable

40

accuracy vs size chartarrow-up-right