Skip to content

Latest commit

 

History

History
27 lines (19 loc) · 943 Bytes

percentilekllmv.md

File metadata and controls

27 lines (19 loc) · 943 Bytes
description
This section contains reference documentation for the PERCENTILEKLLMV function.

PERCENTILEKLLMV

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 please see the accuracy vs size chart.

Usage Examples

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