GitHubContribute in GitHub: Edit online

make_list_with_nulls() (aggregation function)

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

  • Can be used only in context of aggregation inside summarize

Syntax

make_list_with_nulls ( Expr )

Arguments

  • Expr: Expression that will be used for aggregation calculation.

Returns

Returns a dynamic (JSON) array of all the values of Expr in the group, including null values. 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.

TIP

Use the array_sort_asc() or array_sort_desc() function to create an ordered list by some key.