You're viewing version 1.1 of the OpenSearch documentation. This version is no longer maintained. For the latest version, see the current documentation. For information about OpenSearch version maintenance, see Release Schedule and Maintenance Policy.
Data types
The following table shows the data types supported by the PPL plugin and how each one maps to OpenSearch and SQL data types:
| PPL Type | OpenSearch Type | SQL Type |
|---|---|---|
| boolean | boolean | BOOLEAN |
| byte | byte | TINYINT |
| byte | short | SMALLINT |
| integer | integer | INTEGER |
| long | long | BIGINT |
| float | float | REAL |
| float | half_float | FLOAT |
| float | scaled_float | DOUBLE |
| double | double | DOUBLE |
| string | keyword | VARCHAR |
| text | text | VARCHAR |
| timestamp | date | TIMESTAMP |
| ip | ip | VARCHAR |
| timestamp | date | TIMESTAMP |
| binary | binary | VARBINARY |
| struct | object | STRUCT |
| array | nested | STRUCT |
In addition to this list, the PPL plugin also supports the datetime type, though it doesn’t have a corresponding mapping with OpenSearch. To use a function without a corresponding mapping, you must explicitly convert the data type to one that does.
The PPL plugin supports all SQL date and time types. To learn more, see SQL Data Types.