mirror of
https://github.com/elastic/elasticsearch.git
synced 2025-07-01 10:53:25 -04:00
4065510f38
* [DOCS][8.x] ESQL: Document LU JOIN/MV_EXPAND not respecting SORT * Fix nasty asciidoc backticks
38 lines
723 B
Text
38 lines
723 B
Text
[discrete]
|
|
[[esql-mv_expand]]
|
|
=== `MV_EXPAND`
|
|
|
|
preview::[]
|
|
|
|
The `MV_EXPAND` processing command expands multivalued columns into one row per
|
|
value, duplicating other columns.
|
|
|
|
**Syntax**
|
|
|
|
[source,esql]
|
|
----
|
|
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 `SORT` commands. To guarantee a certain ordering, place a `SORT` after any
|
|
`MV_EXPAND` commands.
|
|
======
|
|
|
|
*Example*
|
|
|
|
[source.merge.styled,esql]
|
|
----
|
|
include::{esql-specs}/mv_expand.csv-spec[tag=simple]
|
|
----
|
|
[%header.monospaced.styled,format=dsv,separator=|]
|
|
|===
|
|
include::{esql-specs}/mv_expand.csv-spec[tag=simple-result]
|
|
|===
|