quantileTDigestWeighted

The performance of the function is lower than performance of quantile or . In terms of the ratio of State size to precision, this function is much better than quantile.

The result depends on the order of running the query, and is nondeterministic.

When using multiple quantile* functions with different levels in a query, the internal states are not combined (that is, the query works less efficiently than it could). In this case, use the quantiles function.

Note

Syntax

Alias: medianTDigestWeighted.

Arguments

• level — Level of quantile. Optional parameter. Constant floating-point number from 0 to 1. We recommend using a level value in the range of [0.01, 0.99]. Default value: 0.5. At the function calculates .
• expr — Expression over the column values resulting in numeric data types, or DateTime.

Returned value

• Approximate quantile of the specified level.

• for numeric data type input.
• DateTime if input values have the DateTime type.

Example

Query:

Result:

See Also