Skip to content

Move aggregate functions to source code #4393

@Blargian

Description

@Blargian

Move the following functions into the source code and generate these pages from system tables:

https://clickhouse.com/docs/sql-reference/aggregate-functions/reference

Here's the complete list of ClickHouse aggregate functions as a single list:

  • aggThrow
  • analysisOfVariance
  • any
  • anyHeavy
  • anyLast
  • approx_top_k
  • approx_top_sum
  • argMax
  • argMin
  • avg
  • groupArray
  • groupArrayArray
  • groupArrayLast
  • groupArraySample
  • groupArraySorted

ClickHouse/ClickHouse#87106 -> PR with modifications to allow AggregateFunctions docs

  • avgWeighted
  • boundingRatio
  • categoricalInformationValue
  • contingency
  • corr
  • corrMatrix
  • corrStable
  • count
  • covarPop
  • covarPopMatrix
  • covarPopStable
  • covarSamp
  • covarSampMatrix
  • covarSampStable
  • cramersV
  • cramersVBiasCorrected
  • deltaSum
  • deltaSumTimestamp
  • distinctDynamicTypes
  • distinctJSONPaths
  • entropy
  • estimateCompressionRatio
  • exponentialMovingAverage
  • exponentialTimeDecayedAvg
  • exponentialTimeDecayedCount
  • exponentialTimeDecayedMax
  • exponentialTimeDecayedSum
  • first_value -> this is actually an alias ?
  • flameGraph
  • groupArrayInsertAt
  • groupArrayIntersect
  • groupArrayMovingAvg
  • groupArrayMovingSum
  • groupArraySorted
  • timeSeriesGroupArray
  • groupBitAnd
  • groupBitmap
  • groupBitmapAnd
  • groupBitmapOr
  • groupBitmapXor
  • groupBitOr
  • groupBitXor
  • groupConcat
  • groupUniqArray
  • intervalLengthSum
  • kolmogorovSmirnovTest
  • kurtPop
  • kurtSamp
  • largestTriangleThreeBuckets
  • last_value
  • mannWhitneyUTest
  • max
  • maxIntersections
  • maxIntersectionsPosition
  • maxMap
  • meanZTest
  • median
  • min
  • minMap
  • quantile
  • quantileBFloat16
  • quantileDD
  • quantileDeterministic
  • quantileExact
  • quantileExactWeighted
  • quantileGK
  • quantileExactWeightedInterpolated
  • quantileInterpolatedWeighted
  • quantiles
  • quantileTDigest
  • quantileTDigestWeighted
  • quantileTiming
  • quantileTimingWeighted
  • rankCorr
  • simpleLinearRegression
  • singleValueOrNull
  • skewPop
  • skewSamp
  • sparkbar
  • stddevPop
  • stddevPopStable
  • stddevSamp
  • stddevSampStable
  • stochasticLinearRegression
  • stochasticLogisticRegression
  • studentTTest
  • sum
  • sumCount
  • sumKahan
  • sumMap
  • sumMapWithOverflow
  • sumWithOverflow
  • theilsU
  • timeSeriesDeltaToGrid
  • timeSeriesInstantDeltaToGrid
  • timeSeriesInstantRateToGrid
  • timeSeriesLastTwoSamples
  • timeSeriesRateToGrid
  • timeSeriesResampleToGridWithStaleness
  • timeSeriesDerivToGrid
  • timeSeriesPredictLinearToGrid
  • topK
  • topKWeighted
  • uniq
  • uniqCombined
  • uniqCombined64
  • uniqExact
  • uniqHLL12
  • uniqTheta
  • varPop
  • varPopStable
  • varSamp
  • varSampStable
  • welchTTest
  • distinctDynamicTypes
  • distinctJSONPaths
  • timeSeriesDeltaToGrid
  • timeSeriesInstantDeltaToGrid
  • timeSeriesInstantRateToGrid
  • timeSeriesLastTwoSamples
  • timeSeriesRateToGrid
  • timeSeriesResampleToGridWithStaleness
  • timeSeriesDerivToGrid
  • timeSeriesPredictLinearToGrid
  • timeSeriesChangesToGrid
  • timeSeriesResetsToGrid
  • groupConcat

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions