v.22.11Experimental Feature

Support Nested Object Types in Arrays

Official CH changelog text
Support type Object inside other types, e.g. Array(JSON). #36969 (Anton Popov).
Support for the Object data type nested inside other types, such as Array(JSON), has been added to ClickHouse.

Why it matters

This feature enables more flexible and structured data representation by allowing users to embed the Object type within complex data types like arrays. It solves the limitation of not being able to use Object within other data types, enhancing the ability to model hierarchical or nested JSON-like data directly in ClickHouse tables.

How to use it

Users can define columns with nested Object types inside other types (for example, Array(JSON)) directly in their table schema. Example:

CREATE TABLE example (
    data Array(Object)
) ENGINE = ...

This allows storing arrays of JSON objects efficiently.

Related resources

PreviousNext