📄️ ARRAY
ARRAY, as an extended type of database, is supported in various database systems such as PostgreSQL, ClickHouse, and Snowflake. ARRAY is widely used in scenarios such as A/B tests, user tag analysis, and user profiling. StarRocks supports multidimensional array nesting, array slicing, comparison, and filtering.
📄️ JSON
Since version 2.2.0, StarRocks supports JSON. This article introduces the basic concepts of JSON, and how StarRocks creates JSON-type columns, loads, and queries JSON data, and constructs and processes JSON data through JSON functions and operators.
📄️ MAP
MAP is a complex data type that stores a set of key-value pairs, for example, {a2, c:3}. Keys in a map must be unique. A nested map can contain up to 14 levels of nesting.
📄️ STRUCT
STRUCT is widely used to express complex data types. It represents a collection of elements (also called fields) with different data types, for example, ``.