quantileExactInclusive

Introduced in: v20.1.0 Similar to quantileExact, this computes the exact quantile of a numeric data sequence. This function is equivalent to quantileExact but uses the inclusive method for calculating quantiles, as described in the R-7 method. When using this function, the quantile is calculated such that the interpolation formula for a given quantile p takes the form: x[floor((n-1)*p)] + ((n-1)*p - floor((n-1)*p)) * (x[floor((n-1)*p)+1] - x[floor((n-1)*p)]), where x is the sorted array. To get the exact value, all the passed values are combined into an array, which is then fully sorted. The sorting algorithm’s complexity is O(N·log(N)), where N = std::distance(first, last) comparisons. 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. Syntax

quantileExactInclusive(level)(expr)

Parameters

level — Level of quantile. Constant floating-point number from 0 to 1 (inclusive). We recommend using a level value in the range of [0.01, 0.99]. Float*

Arguments

expr — Expression over the column values resulting in numeric data types, Date or DateTime. (U)Int* or Float* or Decimal* or Date or DateTime

Returned value Returns the quantile of the specified level. Float64 Examples Computing exact inclusive quantile

Query

SELECT quantileExactInclusive(0.25)(number) FROM numbers(5);

Response

┌─quantileExactInclusive(0.25)(number)─┐
│                                    1 │
└──────────────────────────────────────┘

Computing multiple quantile levels

Query

SELECT quantileExactInclusive(0.1)(number), quantileExactInclusive(0.9)(number) FROM numbers(10);

Response

┌─quantileExactInclusive(0.1)(number)─┬─quantileExactInclusive(0.9)(number)─┐
│                                 0.9 │                                 8.1 │
└─────────────────────────────────────┴─────────────────────────────────────┘

​quantileExactInclusive

quantileExactInclusive