Semi-structured
ARRAY
ARRAY, as an extended type of database, is supported in various database systems such as PostgreSQL, ClickHouse, and Snowflake.
JSON
Since version 2.2.0, StarRocks supports JSON.
MAP
MAP is a complex data type that stores a set of key-value pairs, for example, {a:1, b:2, c:3}.
STRUCT
STRUCT is widely used to express complex data types.
VARIANT
The VARIANT type is supported only for tables in Iceberg Catalog.