All Products
Search

This Product

    OpenSearch:Mappings between field types in OpenSearch Vector Search Edition and field types in other Alibaba Cloud services

    Document Center

    OpenSearch:Mappings between field types in OpenSearch Vector Search Edition and field types in other Alibaba Cloud services

    Last Updated:Aug 27, 2024

    Mappings between field types in OpenSearch Vector Search Edition and field types in MaxCompute

    Field type in OpenSearch Vector Search 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.

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

    "\x1D"('^]')

    UINT8

    Single-value field: TINYINT.

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

    "\x1D"('^]')

    INT16

    Single-value field: TINYINT and SMALLINT.

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

    "\x1D"('^]')

    UINT16

    Single-value field: TINYINT and SMALLINT.

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

    "\x1D"('^]')

    INTEGER

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

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

    "\x1D"('^]')

    UINT32

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

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

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

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

    "\x1D"('^]')

    FLOAT

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

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

    "\x1D"('^]')

    DOUBLE

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

    Multivalued 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 Vector Search Edition and field types in ApsaraDB RDS

    Field type in OpenSearch Vector Search Edition

    Field type in ApsaraDB RDS

    TEXT

    String types such as VARCHAR.

    STRING

    String types such as VARCHAR.

    INT8

    Single-value field: TINYINT.

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

    "\x1D"('^]')

    UINT8

    Single-value field: TINYINT.

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

    "\x1D"('^]')

    INT16

    Single-value field: TINYINT and SMALLINT.

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

    "\x1D"('^]')

    UINT16

    Single-value field: TINYINT and SMALLINT.

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

    "\x1D"('^]')

    INTEGER

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

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

    "\x1D"('^]')

    UINT32

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

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

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

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

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

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