Skip to main content
Version: Next

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