make_list() (aggregation function)

Returns a dynamic (JSON) array of all the values of Expr in the group.

  • Can be used only in context of aggregation inside summarize

Syntax

summarize make_list(Expr [, MaxListSize])

Arguments

  • Expr: Expression that will be used for aggregation calculation.
  • MaxListSize is an optional integer limit on the maximum number of elements returned (default is 1048576). MaxListSize value cannot exceed 1048576.

Note

An legacy and obsolete variant of this function: makelist() has a default limit of MaxListSize = 128.

Returns

Returns a dynamic (JSON) array of all the values of Expr in the group. If the input to the summarize operator is not sorted, the order of elements in the resulting array is undefined. If the input to the summarize operator is sorted, the order of elements in the resulting array tracks that of the input.

Tips

Use mv-apply operator in order to create an ordered list by some key. see examples here.