object_agg

Description

Extract aggregated fields and values from a group of rows into a new JSON object.

Returns one OBJECT per group.

For each (key, value) input pair, the resulting object contains a key:value field. The key column needs to be string. Duplicate keys within a group result in an error, and input tuples with NULL key and/or value are ignored.

Return type

object

Domain

This is an aggregate function (aggregates rows over a group in aggregate verbs.)

This is a window function (calculates over a group of multiple input rows using windowing.)

Categories

Usage

object_agg(key, value)

Argument

Type

Optional

Repeatable

Restrictions

key

string

no

no

none

value

storable

no

no

none

Examples

statsby clusterid, oa:object_agg(jobid, status), group_by(clusterid)

For each clusterid, return a JSON object containing the status of each jobid with the attached clusterid.