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).
Why it matters
This feature enables ClickHouse to correctly interpret and flatten nestedArray(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 nestedArray(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.