v.21.12Improvements

Throw Exception for Garbage After Field in JSONCompactStrings Format

Throw an exception if there is some garbage after field in JSONCompactStrings(EachRow) format. #31455 (Kruglov Pavel).
ClickHouse now throws an exception if there is any garbage data after a field when using the JSONCompactStrings(EachRow) format.

Why it matters

This feature improves data integrity and error detection by preventing silent acceptance of malformed JSON input in the JSONCompactStrings(EachRow) format. It helps users identify and fix issues with extra unexpected data following fields in JSON data, ensuring cleaner and more reliable data processing.

How to use it

When using the JSONCompactStrings(EachRow) format for data input or output, ClickHouse will automatically throw an exception if it detects garbage data after a field. No additional configuration is needed from the user to enable this behavior.