本文列举ClickHouse中的聚合函数。
函数名称 | 文档链接 |
count | |
boundingRatio | |
min | |
max | |
sum | |
avg | |
any | |
first_value | |
last_value | |
stddevPop | |
stddevSamp | |
varPop(x) | |
varSamp | |
covarPop | |
covarSamp | |
anyHeavy | |
anyLast | |
argMin | |
argMax | |
avgWeighted | |
corr | |
exponentialmovingaverage | |
topK | |
topKWeighted | |
array_concat_agg | |
groupArray | |
groupArrayLast | |
groupUniqArray | |
groupArrayInsertAt | |
groupArrayMovingSum | |
groupArrayMovingAvg | |
groupArraySample | |
groupBitAnd | |
groupBitOr | |
groupBitXor | |
groupBitmap | |
groupBitmapAnd | |
groupBitmapOr | |
groupBitmapXor | |
sumWithOverflow | |
deltaSum | |
deltaSumTimestamp | |
sumMap | |
minMap | |
maxMap | |
sumCount | |
rankCorr | |
sumKahan | |
intervalLengthSum | |
skewPop | |
skewSamp | |
kurtPop | |
kurtSamp | |
uniq | |
uniqExact | |
uniqCombined | |
uniqCombined64 | |
uniqHLL12 | |
uniqTheta | |
quantile | |
quantiles Functions | |
quantileExact Functions | |
quantileExactWeighted | |
quantileInterpolatedWeighted | |
quantileGK | |
quantileTiming | |
quantileTimingWeighted | |
quantileDeterministic | |
quantileTDigest | |
quantileTDigestWeighted | |
quantileBFloat16 | |
median | |
simpleLinearRegression | |
stochasticLinearRegression | |
stochasticLogisticRegression | |
categoricalInformationValue | |
kolmogorovSmirnovTest | |
studentTTest | |
welchTTest | |
entropy | |
meanZTest | |
mannWhitneyUTest | |
sparkbar | |
contingency | |
cramersV | |
cramersVBiasCorrected | |
theilsU | |
maxIntersections | |
maxIntersectionsPosition | |
Aggregate Function Combinators | |
Parametric Aggregate Functions | |
GROUPING |