v.24.1New Feature

Allow Reading Bool Values as Strings in JSON Input Formats

Allow to read Bool values into String in JSON input formats. It's done under a setting input_format_json_read_bools_as_strings that is enabled by default. #58561 (Kruglov Pavel).
Allows reading Boolean values as strings when using JSON input formats in ClickHouse.

Why it matters

This feature addresses scenarios where Boolean values in JSON input need to be interpreted as strings rather than native Boolean types. It enhances flexibility in data ingestion by accommodating systems or workflows that expect Booleans to be handled as string values.

How to use it

The behavior is controlled by the setting input_format_json_read_bools_as_strings, which is enabled by default. Users can verify or modify this setting to control whether Boolean values are read as strings during JSON input processing.