ES|QL TO_STRING function
field-
Input value. The input can be a single- or multi-valued column or an expression.
Converts an input value into a string.
| field | result |
|---|---|
| aggregate_metric_double | keyword |
| boolean | keyword |
| cartesian_point | keyword |
| cartesian_shape | keyword |
| date | keyword |
| date_nanos | keyword |
| dense_vector | keyword |
| double | keyword |
| exponential_histogram
|
keyword |
| geo_point | keyword |
| geo_shape | keyword |
| geohash | keyword |
| geohex | keyword |
| geotile | keyword |
| histogram
|
keyword |
| integer | keyword |
| ip | keyword |
| keyword | keyword |
| long | keyword |
| text | keyword |
| unsigned_long | keyword |
| version | keyword |
ROW a=10
| EVAL j = TO_STRING(a)
| a:integer | j:keyword |
|---|---|
| 10 | "10" |
It also works fine on multivalued fields:
ROW a=[10, 9, 8]
| EVAL j = TO_STRING(a)
| a:integer | j:keyword |
|---|---|
| [10, 9, 8] | ["10", "9", "8"] |