median
The median*
functions are the aliases for the corresponding quantile*
functions. They calculate median of a numeric data sample.
Functions:
median
β Alias for quantile.medianDeterministic
β Alias for quantileDeterministic.medianExact
β Alias for quantileExact.medianExactWeighted
β Alias for quantileExactWeighted.medianTiming
β Alias for quantileTiming.medianTimingWeighted
β Alias for quantileTimingWeighted.medianTDigest
β Alias for quantileTDigest.medianTDigestWeighted
β Alias for quantileTDigestWeighted.medianBFloat16
β Alias for quantileBFloat16.
Example
Input table:
ββvalββ
β 1 β
β 1 β
β 2 β
β 3 β
βββββββ
Query:
SELECT medianDeterministic(val, 1) FROM t;
Result:
ββmedianDeterministic(val, 1)ββ
β 1.5 β
βββββββββββββββββββββββββββββββ