ES|QL ROW command
Serverless Stack
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.
Examples
ROW a = 1, b = "two", c = null
| a:integer | b:keyword | c:null |
|---|---|---|
| 1 | "two" | null |
Use square brackets to create multi-value columns:
ROW a = [2, 1]
ROW supports the use of functions:
ROW a = ROUND(1.23, 0)