v.18.12Improvement
Fix for Skipping Unknown Fields in JSONEachRow Format with input_format_skip_unknown_fields Enabled
When theinput_format_skip_unknown_fieldssetting is enabled, object fields inJSONEachRowformat are skipped correctly. BlahGeek
Why it matters
This feature addresses the issue where unknown fields in JSON objects were not skipped properly during import using theJSONEachRow 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 settinginput_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