Aggregate

Function Name Description
AVG Computes the average of a set of values.
CORR Calculates the covariance of the values expression1 and expression2. The function name must be enclosed in double quotes ("CORR").
COUNT Returns the total number of records for the specified expression.
HLL Uses HyperLogLog to return an approximation of the distint cardinality of the input.
MAX Returns the maximum value for the non-NULL input expressions.
MIN Returns the minimum value for the non-NULL input expressions.
SUM Returns the sum of non-NULL input expressions.
VAR_POP Returns the population variance of non-NULL records.
VAR_SAMP Returns the sample variance of non-NULL records.