percentilerawkllmv

This section contains reference documentation for the PERCENTILERAWKLLMV function.

Variant of the PERCENTILERAWKLL aggregation function which accepts multi-value columns. Values in the given column are 'flattened' before aggregation.

Signature

PercentileRAWKLLMV(column, percentile) -> Double

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

  • percentile (required): Percentile value to be calculated [0..100]. For raw versions of the function, this value is used for ordering (ORDER BY).

Usage Examples

select percentileKLLMV(ArrOfInts, 90) as value
from MyTable