Back to Elasticsearch

Mv Union

docs/reference/query-languages/esql/kibana/docs/functions/mv_union.md

9.4.1393 B
Original Source

% This is generated by ESQL's AbstractFunctionTestCase. Do not edit it. See ../README.md for how to regenerate it.

MV UNION

Returns all unique values from the combined input fields (set union). Null values are treated as empty sets; returns null only if both fields are null.

esql
ROW a = [1, 2, 3, 4, 5], b = [2, 3, 4, 5, 6]
| EVAL finalValue = MV_UNION(a, b)
| KEEP finalValue