Skip to main content
Version: current [24.3.x]

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 TypeDremio Type
ATTACHMENTVARBINARY
BINARYVARBINARY
BOOLEANBOOLEAN
BYTEINTEGER
SCALE_FLOATDOUBLE
DATEDATE
DOUBLEDOUBLE
FLOATFLOAT
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_FLOATFLOAT
INTEGERINTEGER
IPVARCHAR
KEYWORDVARCHAR
LONGBIGINT
SHORTINTEGER
STRINGVARCHAR
TEXTVARCHAR
TIMETIME
TIMESTAMPTIMESTAMP