Module functions

Module functions 

Source
Expand description

Concrete implementations of aggregate functions

Structsยง

AvgFunction
AVG(column) - averages numeric values
CountFunction
COUNT(column) - counts non-null values
CountStarFunction
COUNT(*) - counts all rows including nulls
MaxFunction
MAX(column) - finds maximum value
MedianFunction
MEDIAN(column) - finds the median value
MinFunction
MIN(column) - finds minimum value
ModeFunction
MODE(column) - finds the most frequently occurring value
PercentileFunction
PERCENTILE(column, percentile) - finds the nth percentile value
StdDevFunction
STDDEV(column) - computes population standard deviation
StdDevPopFunction
STDDEV_POP(column) - computes population standard deviation (same as STDDEV)
StdDevSampFunction
STDDEV_SAMP(column) - computes sample standard deviation
StringAggFunction
STRING_AGG(column, separator) - concatenates strings with separator
SumFunction
SUM(column) - sums numeric values
VarPopFunction
VAR_POP(column) - computes population variance (same as VARIANCE)
VarSampFunction
VAR_SAMP(column) - computes sample variance
VarianceFunction
VARIANCE(column) - computes population variance