v.23.4Improvement

Support Additional ClickHouse Types in ORC, Arrow, and Parquet Formats

Support more ClickHouse types in ORC/Arrow/Parquet formats: Enum(8|16), (U)Int(128|256), Decimal256 (for ORC), allow reading IPv4 from Int32 values (ORC outputs IPv4 as Int32, and we couldn't read it back), fix reading Nullable(IPv6) from binary data for ORC. #48126 (Kruglov Pavel).
Added support for more ClickHouse data types in ORC, Arrow, and Parquet formats, including Enum(8|16), (U)Int(128|256), and Decimal256 (for ORC). Improved reading of IPv4 stored as Int32 in ORC and fixed reading Nullable(IPv6) from binary data in ORC files.

Why it matters

This feature addresses limitations in ClickHouse's ability to read and write certain complex data types and IP address formats from ORC, Arrow, and Parquet files. It ensures better compatibility and correctness when importing or exporting data involving extended integer types, enums, decimals, and IP addresses, thus enhancing interoperability and data integrity.

How to use it

The support for these additional types and fixes is integrated into ClickHouse's native handling of ORC, Arrow, and Parquet formats. Users do not need to enable anything explicitly; simply reading or writing these formats with the new ClickHouse version will automatically support the extended types and improved IP address handling.