1 of 1

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

sketch

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

sketch