Dremio Cloud
Dremio Software
 
On this page

    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