Link Search Menu Expand Document

The Open Distro project is archived. Open Distro development has moved to OpenSearch. The Open Distro plugins will continue to work with legacy versions of Elasticsearch OSS, but we recommend upgrading to OpenSearch to take advantage of the latest features and improvements.

Data types

The following table shows the data types supported by the PPL plugin and how each one maps to Elasticsearch and SQL data types:

PPL Type Elasticsearch 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
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 Elasticsearch. 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.