Loading

ES|QL MV_SORT function

Embedded
field
Multivalue expression. If null, the function returns null.
order

Sort order. The valid options are ASC and DESC, the default is ASC.

Sorts a multivalued field in lexicographical order.

field order result
boolean keyword boolean
date keyword date
date_nanos keyword date_nanos
double keyword double
integer keyword integer
ip keyword ip
keyword keyword keyword
long keyword long
text keyword keyword
version keyword version 
ROW a = [4, 2, -3, 2]
| EVAL sa = mv_sort(a), sd = mv_sort(a, "DESC")
a:integer sa:integer sd:integer
[4, 2, -3, 2] [-3, 2, 2, 4] [4, 2, 2, -3]