v.18.12Improvement

Fix for Skipping Unknown Fields in JSONEachRow Format with input_format_skip_unknown_fields Enabled

When the input_format_skip_unknown_fields setting is enabled, object fields in JSONEachRow format are skipped correctly. BlahGeek
Improved handling of unknown object fields when using the JSONEachRow input format with the input_format_skip_unknown_fields setting enabled.

Why it matters

This feature addresses the issue where unknown fields in JSON objects were not skipped properly during import using the JSONEachRow format. It ensures that any fields not defined in the table schema are correctly ignored, preventing parsing errors and improving data import robustness.

How to use it

Enable the setting input_format_skip_unknown_fields to allow ClickHouse to skip unknown object fields when importing data in the JSONEachRow format. This can be set globally or per session using:

SET input_format_skip_unknown_fields = 1