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