v.23.1Improvement

Added Parallel Parsing and Formatting Support to system.formats Table

Added fields supports_parallel_parsing and supports_parallel_formatting to table system.formats for better introspection. #45499 (Anton Popov).
Added supports_parallel_parsing and supports_parallel_formatting fields to the system.formats table to provide enhanced introspection of format capabilities in ClickHouse.

Why it matters

This feature helps users identify which data formats support parallel parsing and parallel formatting, enabling better decision-making and optimization when working with data ingestion and output formats in ClickHouse.

How to use it

Query the system.formats table to check the values of the supports_parallel_parsing and supports_parallel_formatting columns for each format, for example:

SELECT name, supports_parallel_parsing, supports_parallel_formatting
FROM system.formats
WHERE supports_parallel_parsing OR supports_parallel_formatting