v.23.3Improvement

Allow Simplified Column Naming for Nested Arrays in Protobuf Format

Official CH changelog text
Allow reading/writing nested arrays in Protobuf format with only the root field name as column name. Previously column name should've contained all nested field names (like a.b.c Array(Array(Array(UInt32))), now you can use just a Array(Array(Array(UInt32))). #47650 (Kruglov Pavel).
Support reading and writing nested arrays in Protobuf format using only the root field name as the column name, simplifying column naming for deeply nested array structures.

Why it matters

This feature addresses the complexity and verbosity of specifying full nested field paths as column names (e.g., a.b.c Array(Array(Array(UInt32)))) when handling nested arrays in Protobuf format. By allowing just the root field name (e.g., a Array(Array(Array(UInt32)))), it simplifies schema definitions and improves usability when working with nested array data in Protobuf format.

How to use it

To use this feature, define columns with only the root field name for nested arrays in your table schema and use the Protobuf format for reading or writing data. For example, instead of specifying the full nested path in the column name, just specify the root name with the nested array type:

CREATE TABLE example (
  a Array(Array(Array(UInt32)))
) ENGINE = ...
FORMAT Protobuf


This enables the data operation without requiring detailed nested field naming.

Related resources

PreviousNext