ποΈ 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, ``.