v.23.1New Feature

Support for Nested Tables and Decimal Types in CapnProto Format for ClickHouse

Official CH changelog text
Support reading/writing Nested tables as List of Struct in CapnProto format. Read/write Decimal32/64 as Int32/64. Closes #43319. #43379 (Kruglov Pavel).
Support for reading and writing Nested tables as List of Struct types in the CapnProto format, along with reading and writing Decimal32 and Decimal64 types as Int32 and Int64 respectively.

Why it matters

This feature enables better compatibility and interoperability between ClickHouse and systems using the CapnProto serialization format by correctly mapping nested and decimal types. It solves the issue of handling complex data structures like Nested tables and high-precision decimals during data exchange, improving data fidelity and client application support.

How to use it

When using CapnProto format for input or output, ClickHouse will automatically read and write Nested tables as List of Struct and convert Decimal32/Decimal64 types as Int32/Int64. Users only need to specify the CapnProto format in their queries or data operations without additional configuration.

Related resources

PreviousNext