Scalar FunctionsOther Functions

percentrank_tdigest

Return the approximate percentile rank of `value` in a t-digest / DDSketch sketch produced by the `tdigest()` aggregate.

Equivalent to 100 * rank_tdigest(sketch, value) / total_count. Empty sketch yields NaN.

Syntax

percentrank_tdigest(sketch, value)

Prop

Type

Returns: real

print percentrank_tdigest(toscalar(), 50)

print_0 (real)
50.0

percentile_tdigest

Calculate the percentile from a t-digest representation.

Returns the value of a column from a row at a given offset before the current row in a serialized row set.