Back to Elasticsearch

Mv Intersection

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

9.4.0368 B
Original Source

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

MV INTERSECTION

Returns the values that appear in both input fields. Returns null if either field is null or if no values match.

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