v.25.8Improvement

Introduce settings

Introduce settings to set ORC compression block size, and update its default value from 64KB to 256KB to keep consistent with spark or hive. #80602 (李扬).
Introduces new settings to configure the ORC compression block size, and updates the default block size from 64KB to 256KB to align with Apache Spark and Hive standards.

Why it matters

This feature addresses the inconsistency in ORC compression block sizes between ClickHouse and other big data processing systems like Spark and Hive. By increasing the default block size to 256KB and allowing users to configure it, ClickHouse improves compatibility and potentially enhances compression efficiency and performance when working with ORC files.

How to use it

Users can modify the ORC compression block size by setting the new configuration options in their ClickHouse server or client settings. The default block size is now 256KB, but it can be customized as needed to optimize compression behavior. These settings are typically adjusted in the ClickHouse configuration files or session settings.