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
Example
Section titled “Example”SELECT to_aggregate_state({'count': 1, 'value': 42.0}, 'avg', ['DOUBLE']);