Aggregate Functions
Aggregate functions appear in either summarization or expression context and produce an aggregate value for a sequence of input values.
- and - logical AND of input values
- any - select an arbitrary value from its input
- avg - average value
- collect - aggregate values into array
- collect_map - aggregate map values into a single map
- count - count input values
- dcount - count distinct input values
- fuse - compute a fused type of input values
- max - maximum value of input values
- min - minimum value of input values
- or - logical OR of input values
- sum - sum of input values
- union - set union of input values