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