Elasticsearch Data Types

Dremio supports selecting the following Elasticsearch Database types. The following table shows the mappings from Elasticsearch to Dremio data types. If there are additional Elasticsearch types not listed in the table, then those types are not supported in Dremio.

Elasticsearch Database Type	Dremio Type
ATTACHMENT	VARBINARY
BINARY	VARBINARY
BOOLEAN	BOOLEAN
BYTE	INTEGER
SCALE_FLOAT	DOUBLE
DATE	DATE
DOUBLE	DOUBLE
FLOAT	FLOAT
GEO_POINT	{ "lat": DOUBLE, "long": DOUBLE }
GEO_SHAPE	{ "type": VARCHAR, "coordinates": { DOUBLE, [{ DOUBLE, [{ DOUBLE, [{ DOUBLE, [{ DOUBLE, [DOUBLE] }] }] }] }], }, "radius": VARCHAR, "orientation": VARCHAR, "geometries": [ { "type": VARCHAR, "coordinates": { DOUBLE, [{ DOUBLE, [{ DOUBLE, [{ DOUBLE, [{ DOUBLE, [DOUBLE] }] }] }] }], }, "radius": VARCHAR, "orientation": VARCHAR } ] }
HALF_FLOAT	FLOAT
INTEGER	INTEGER
IP	VARCHAR
KEYWORD	VARCHAR
LONG	BIGINT
SHORT	INTEGER
STRING	VARCHAR
TEXT	VARCHAR
TIME	TIME
TIMESTAMP	TIMESTAMP