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 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