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

serverless: ga
stack: ga

The ROW source command produces a row with one or more columns with values that you specify. This can be useful for testing.

Syntax

ROW column1 = value1[, ..., columnN = valueN]

Parameters

columnX : The column name.

In case of duplicate column names, only the rightmost duplicate creates a column.

valueX : The value for the column. Can be a literal, an expression, or a

[function](/reference/query-languages/esql/esql-functions-operators.md#esql-functions).

Examples

:::{include} ../examples/row.csv-spec/example.md :::

Use square brackets to create multi-value columns:

:::{include} ../examples/row.csv-spec/multivalue.md :::

ROW supports the use of functions:

:::{include} ../examples/row.csv-spec/function.md :::