Data types that are supported by SQL
The data types that are supported by SQL are divided into the following three categories:
Atomic type: a basic data type.
Array type: the type of a multivalued field that contains elements of an atomic type.
Multiset type: the type of a child table that contains values of multiple atomic types or array types.
The following atomic types are supported:
INT8
INT16
INT32 or INTEGER
INT64 or LONG
FLOAT
DOUBLE
STRING
For more information about the data types supported by the system, see Built-in field types.
Data types of UDF or UDAF parameters
Parameters of user-defined functions (UDFs) or user-defined aggregation functions (UDAFs) do not support multiset types. Other data types that are supported for parameters of UDFs or UDAFs are the same as the data types that are supported by SQL.
Type conversion
In OpenSearch Vector Search Edition, the data types in a schema are automatically converted to the data types supported by SQL. The unsigned types in the schema are automatically converted to the signed types because SQL does not support unsigned types. Therefore, execution errors may occur due to type match failures or overflows. We recommend that you do not use the type conversion feature.
If data types are inconsistent, you can use the CAST operator to convert data types.