v.22.4Improvement

Add input_format_json_read_bools_as_numbers setting to parse bools as numbers in JSON

Official CH changelog text
Add new setting input_format_json_read_bools_as_numbers that allows to infer and parse bools as numbers in JSON input formats. It's enabled by default. Suggested by @alexey-milovidov. #35735 (Kruglov Pavel).
Added a new setting input_format_json_read_bools_as_numbers that allows boolean values to be inferred and parsed as numbers in JSON input formats.

Why it matters

This feature addresses the need to handle JSON inputs where boolean values are represented as numbers, improving flexibility and compatibility when importing JSON data into ClickHouse.

How to use it

The setting input_format_json_read_bools_as_numbers is enabled by default. Users can disable or enable it by setting it explicitly in the client or server configuration. For example:

SET input_format_json_read_bools_as_numbers = 1;


or

SET input_format_json_read_bools_as_numbers = 0;

Related resources

PreviousNext