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.

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 200 which corresponds to a normalized rank error of about 1.65%. For details, see the accuracy vs size chart.

Usage Examples

select percentileKLLMV(ArrOfInts, 90) as value
from MyTable
value

40