Scalar FunctionsOther Functions
rank_tdigest
Return the approximate count of items ≤ `value` in a t-digest /
Syntax
rank_tdigest(sketch, value)Parameters
Prop
Type
Returns: real
Examples
Example 1
print rank_tdigest(toscalar(), 50)| print_0 (real) |
|---|
| 50.0 |
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.
row_cumsum
Calculates the cumulative sum of a column in a serialized row set. An optional restart argument resets the running sum to the current row's value when true. 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.