quantile() function

*Function type: Aggregate or Selector
**
Output data type:* Float | Record

When using the estimate_tdigest or exact_mean methods, it outputs non-null records with values that fall within the specified quantile.

When using the method, it outputs the non-null record with the value that represents the specified quantile.

The column to use to compute the quantile. Defaults to "_value".

A value between 0 and 1 indicating the desired quantile.

*Data type: Float*

Defines the method of computation.

*Data type: String*

estimate_tdigest

An aggregate method that uses a t-digest data structure to compute an accurate quantile estimate on large data sources.

exact_mean

An aggregate method that takes the average of the two points closest to the quantile value.

exact_selector

A selector method that returns the data point for which at least q points are less than.

Indicates how many centroids to use when compressing the dataset. A larger number produces a more accurate result at the cost of increased memory requirements. Defaults to .

Examples

Quantile as an aggregate
Quantile as a selector

Related articles