All Products
Search

This Product

    OpenSearch:Mappings between field types in OpenSearch Retrieval Engine Edition and field types in other Alibaba Cloud services

    Document Center

    OpenSearch:Mappings between field types in OpenSearch Retrieval Engine Edition and field types in other Alibaba Cloud services

    Last Updated:Jun 18, 2024

    Mappings between field types in OpenSearch Retrieval Engine Edition and field types in MaxCompute

    Field type in OpenSearch Retrieval Engine Edition

    Field type in MaxCompute

    TEXT

    String types such as VARCHAR and STRING.

    STRING

    String types such as VARCHAR and STRING.

    INT8

    Single-value field: TINYINT.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    UINT8

    Single-value field: TINYINT.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    INT16

    Single-value field: TINYINT and SMALLINT.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    UINT16

    Single-value field: TINYINT and SMALLINT.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    INTEGER

    Single-value field: TINYINT, SMALLINT, and INT.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    UINT32

    Single-value field: TINYINT, SMALLINT, and INT.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    INT64

    Single-value field: TINYINT, SMALLINT, INT, and BIGINT.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    UINT64

    Single-value field: TINYINT, SMALLINT, INT, and BIGINT.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    FLOAT

    Single-value field: FLOAT and INT. An integer value must be in the value range of the FLOAT data type.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    DOUBLE

    Single-value field: DOUBLE, FLOAT, and INT.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    LOCATION

    String types such as VARCHAR and STRING.

    LINE

    String types such as VARCHAR and STRING.

    POLYGON

    String types such as VARCHAR and STRING.

    DATE

    DATE

    TIME

    String types such as VARCHAR and STRING.

    TIMESTAMP

    DATETIME and TIMESTAMP.

    Important

    MaxCompute data sources support only the following five data types:

    • STRING

    • BOOLEAN

    • DOUBLE

    • BIGINT

    • DATETIME

    Mappings between field types in OpenSearch Retrieval Engine Edition and field types in ApsaraDB RDS

    Field type in OpenSearch Retrieval Engine Edition

    Field type of ApsaraDB RDS for MySQL

    TEXT

    String types such as VARCHAR.

    STRING

    String types such as VARCHAR.

    INT8

    Single-value field: TINYINT.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    UINT8

    Single-value field: TINYINT.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    INT16

    Single-value field: TINYINT and SMALLINT.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    UINT16

    Single-value field: TINYINT and SMALLINT.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    INTEGER

    Single-value field: TINYINT, SMALLINT, and INTEGER.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    UINT32

    Single-value field: TINYINT, SMALLINT, and INTEGER.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    INT64

    Single-value field: TINYINT, SMALLINT, INTEGER, and BIGINT.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    UINT64

    Single-value field: TINYINT, SMALLINT, INTEGER, and BIGINT.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    FLOAT

    Single-value field: FLOAT, NUMERIC, and INTEGER. An integer value must be in the value range of the FLOAT data type.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    DOUBLE

    Single-value field: DOUBLE, NUMERIC, FLOAT, and INTEGER.

    Multi-value field: string types such as VARCHAR and STRING. Separate multiple values with the following expression:

    "\x1D"('^]')

    LOCATION

    String types such as VARCHAR and STRING.

    LINE

    String types such as VARCHAR and STRING.

    POLYGON

    String types such as VARCHAR and STRING.

    DATE

    DATE

    TIME

    TIME

    TIMESTAMP

    DATETIME and TIMESTAMP.