Skip to content

SQL Reference

TO_AGGREGATE_STATE

to_aggregate_state(data, name, signature, constant_parameters, order_by)

Section titled “to_aggregate_state(data, name, signature, constant_parameters, order_by)”
  • data: ANY
  • name: VARCHAR
  • signature: ANY[]
  • constant_parameters: ANY
  • order_by: ANY
SELECT to_aggregate_state({'count': 1, 'value': 42.0}, 'avg', ['DOUBLE']);