ES|QL ROW command
The ROW source command produces a row with one or more columns with values
that you specify. This can be useful for testing.
ROW column1 = value1[, ..., columnN = valueN]
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.
The following examples demonstrate common ROW patterns.
ROW a = 1, b = "two", c = null
| a:integer | b:keyword | c:null |
|---|---|---|
| 1 | "two" | null |
Use square brackets to create a column with multiple values:
ROW a = [2, 1]
ROW a = ROUND(1.23, 0)