BIGINT |
LONG |
None. |
BINARY |
BINARY |
None. |
BIT |
LONG |
If the data is only one byte long, we recommend that you use the BOOLEAN type in Elasticsearch. |
BLOB |
BINARY |
None. |
BOOL/BOOLEAN |
BOOLEAN |
None. |
CHAR |
TEXT |
None. |
DATE |
DATE |
The DATE format is yyyy-MM-dd, in UTC. For more information, see Date format mappings.
|
DATETIME |
DATE |
The DATE format is yyyy-MM-dd'T'HH:mm:ss, in UTC. If DATE is accurate to microseconds,
its format is yyyy-MM-dd'T'HH:mm:ss.S. For more information, see Date format mappings.
|
DECIMAL/DEC |
DOUBLE |
If the DECIMAL value contains a decimal point, we recommend that you use the TEXT
type in Elasticsearch to ensure data consistency.
|
DOUBLE |
DOUBLE |
None. |
FLOAT |
FLOAT |
None. |
GEOMETRY |
GEO_SHAPE |
None. |
GEOMETRYCOLLECTION |
GEO_SHAPE |
None. |
INT |
INTEGER |
If the data type of the source database is UNSIGNED INT, we recommend that you use
the LONG type in Elasticsearch.
|
JSON |
OBJECT |
If the data is only one byte long, we recommend that you use the BOOLEAN type in Elasticsearch. |
LINESTRING |
GEO_SHAPE |
None. |
LONGTEXT |
TEXT |
None. |
MEDIUMINT |
INTEGER |
None. |
MEDIUMTEXT |
TEXT |
None. |
MULTILINESTRING |
GEO_SHAPE |
None. |
MULTIPOINT |
GEO_SHAPE |
If the data is only one byte long, we recommend that you use the BOOLEAN type in Elasticsearch. |
MULTIPOLYGON |
GEO_SHAPE |
None. |
POINT |
GEO_POINT |
None. |
POLYGON |
GEO_SHAPE |
None. |
REAL |
DOUBLE |
None. |
SMALLINT |
SHORT |
If the data type of the source database is UNSIGNED SMALLINT, we recommend that you
use the INTEGER type in Elasticsearch.
|
TIME |
DATE |
The DATE format is HH:mm:ss, in UTC. If DATE is accurate to microseconds, its format
is HH:mm:ss.S. For more information, see Date format mappings.
|
TIMESTAMP |
DATE |
The DATE format is yyyy-MM-dd'T'HH:mm:ss, in UTC. If DATE is accurate to microseconds,
its format is yyyy-MM-dd'T'HH:mm:ss.S. For more information, see Date format mappings.
|
TINYINT |
SHORT |
If the data type of the source database is UNSIGNED TINYINT, we recommend that you
use the INTEGER type in Elasticsearch.
|
TINYTEXT |
TEXT |
None. |
VARCHAR |
TEXT |
None. |
YEAR |
DATE |
The DATE format is yyyy, in UTC. For more information, see Date format mappings.
|