v.22.9Improvement

Support Reading Array(Record) into Flatten Nested Table in Avro

Support reading Array(Record) into flatten nested table in Avro. #40534 (Kruglov Pavel).
Support reading Array(Record) data types into flattened nested tables when importing Avro format files.

Why it matters

This feature enables ClickHouse to correctly interpret and flatten nested Array(Record) structures found in Avro data files. It solves the problem of processing complex nested data in Avro by automatically transforming it into a normalized table format, improving usability and compatibility with Avro data pipelines.

How to use it

When reading Avro files that contain nested Array(Record) fields, ClickHouse will now automatically flatten these structures into nested tables during import. Users just need to use the standard FORMAT Avro clause in their INSERT or SELECT queries without additional settings.