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.

    Note:
    If a type is not present in the table, it is not currently supported.

    Elasticsearch Database TypeDremio Type
    attachmentvarbinary
    binaryvarbinary
    booleanboolean
    byteint
    scale_floatdouble (as of Dremio 4.0)
    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