Expand description
Aggregate functions for ClickHouse
Structs§
- Aggregate
Expr - Aggregate expression wrapper
- Any
- ANY function
- AnyLast
- ANY_LAST function
- ArgMax
Expr - ArgMax expression
- ArgMin
Expr - ArgMin expression
- Avg
- AVG function
- Count
- COUNT function
- Group
Array - GROUP_ARRAY function
- Group
Array IfExpr - GroupArrayIf expression
- Max
- MAX function
- Min
- MIN function
- Quantile
Expr - Quantile expression
- Star
- Star expression for COUNT(*)
- Sum
- SUM function
- TopK
Expr - TopK expression
- Uniq
- UNIQ function (HyperLogLog approximate)
- Uniq
Exact - UNIQ_EXACT function (exact unique count)
Traits§
- Aggregate
Fn - Trait for aggregate functions
Functions§
- any
- any(expr) - any value (non-deterministic)
- any_
last - anyLast(expr) - last value seen
- arg_max
- argMax(arg, val) - value of arg where val is maximum
- arg_min
- argMin(arg, val) - value of arg where val is minimum
- avg
- avg(expr) - average of values
- count
- count(expr) - count non-null values
- count_
all - count(*) - count all rows
- group_
array - groupArray(expr) - collect values into array
- group_
array_ if - groupArrayIf(expr, condition) - collect values where condition is true
- max
- max(expr) - maximum value
- min
- min(expr) - minimum value
- quantile
- quantile(level)(expr) - quantile at given level
- sum
- sum(expr) - sum of values
- top_k
- topK(N)(expr) - top N most frequent values
- uniq
- uniq(expr) - approximate unique count (HyperLogLog)
- uniq_
exact - uniqExact(expr) - exact unique count