Beam Calcite SQL aggregate functions
This page documents Apache Calcite aggregate functions supported by Beam Calcite SQL.
| Operator syntax | Description |
|---|---|
| COUNT(*) | Returns the number of input rows |
| AVG(numeric) | Returns the average (arithmetic mean) of numeric across all input values |
| SUM(numeric) | Returns the sum of numeric across all input values |
| MAX(value) | Returns the maximum value of value across all input values |
| MIN(value) | Returns the minimum value of value across all input values |