Expand description
Aggregation Framework
Provides aggregation functions for query results.
§Supported Functions
- COUNT: Count rows (including COUNT(*) and COUNT DISTINCT)
- SUM: Sum numeric values
- AVG: Average of numeric values
- MIN: Minimum value
- MAX: Maximum value
- STDDEV: Standard deviation
- VARIANCE: Statistical variance
- PERCENTILE: Nth percentile value
§GROUP BY
Aggregations can be grouped by one or more columns. HAVING clause filters groups after aggregation.
Structs§
- Aggregation
Def - Definition of an aggregation to compute
- AvgAggregator
- AVG aggregator
- Count
Aggregator - COUNT aggregator
- Count
Distinct Aggregator - COUNT DISTINCT aggregator
- Group
Concat Aggregator - GROUP_CONCAT aggregator
- MaxAggregator
- MAX aggregator
- MinAggregator
- MIN aggregator
- Percentile
Aggregator - Percentile aggregator
- Sample
Aggregator - SAMPLE aggregator (returns first non-null value)
- StdDev
Aggregator - Standard deviation aggregator
- SumAggregator
- SUM aggregator
- Variance
Aggregator - Variance aggregator
Traits§
- Aggregator
- Trait for aggregation functions
Functions§
- create_
aggregator - Create an aggregator by name
- execute_
group_ by - 1-pass streaming GROUP BY.
- execute_
having - Execute HAVING clause (filter on aggregated results)