elasticsearch/docs/reference/query-languages/esql/_snippets/commands/layout/mv_expand.md

MV_EXPAND [esql-mv_expand]

::::{warning} This functionality is in technical preview and may be changed or removed in a future release. Elastic will work to fix any issues, but features in technical preview are not subject to the support SLA of official GA features. ::::

The MV_EXPAND processing command expands multivalued columns into one row per value, duplicating other columns.

Syntax

MV_EXPAND column

Parameters

column : The multivalued column to expand.

::::{warning} The output rows produced by MV_EXPAND can be in any order and may not respect preceding SORTs. To guarantee a certain ordering, place a SORT after any MV_EXPANDs. ::::

Example

:::{include} ../examples/mv_expand.csv-spec/simple.md :::