Support for Multi-Dimensional Arrays and Tuples in Tables

Why it matters

This feature was created to enable ClickHouse users to store and efficiently work with complex data structures such as multi-dimensional arrays and tuples directly within tables. It solves the limitation of only supporting one-dimensional arrays and basic types, allowing more flexible and expressive data modeling. This adds value by simplifying the representation of multidimensional data and composite types in analytical queries and storage.

How to use it

Define columns in your table schema using multi-dimensional Array types and the Tuple data type. For example, use Array(Array(Int32)) for 2D arrays or Tuple(Int32, String, Array(Float64)) for tuples combining multiple types. You can then insert and query data using these types in your usual INSERT and SELECT statements.