Scalar FunctionsOther Functions
percentrank_tdigest
Return the approximate percentile rank of `value` in a t-digest /
Syntax
percentrank_tdigest(sketch, value)Parameters
Prop
Type
Returns: real
Examples
Example 1
print percentrank_tdigest(toscalar(), 50)| print_0 (real) |
|---|
| 50.0 |
percentile_tdigest
Calculate the percentile from a t-digest representation.
prev
Returns the value of a column from a row at a given offset before the current row in a serialized row set. A row set is serialized by the sort, top, top-hitters, or serialize operators; order-preserving operators (extend, project, where, ...) keep that property. Only valid in a serialized context.