Skip to main contentModule aggregate
Source - avg
- AVG(expr) - Average of values
- count
- COUNT(*) / COUNT(expr) - Count rows or non-null values
- count_distinct
- COUNT(DISTINCT expr) - Count distinct non-null values
- group_concat
- GROUP_CONCAT(expr, separator) - Concatenate strings from group
- max
- MAX(expr) - Maximum value
- min
- MIN(expr) - Minimum value
- stddev_pop
- STDDEV(expr) / STDDEV_POP(expr) - Standard deviation (population) with parallel support
- sum
- SUM(expr) - Sum of values with automatic parallelization for large datasets
- var_pop
- VARIANCE(expr) / VAR_POP(expr) - Variance (population) with parallel support