v.25.12New Feature
Disable exceptions
Add setting type_json_skip_invalid_typed_paths to disable exceptions for inserts/type casts to JSON type when input JSON cannot be cast to explicit typed paths in JSON type. Falls back to null/zero value of typed path. #89886 (Max Justus Spransy).Why it matters
This feature addresses the issue where inserting or casting JSON data to a JSON type with explicit typed paths would raise exceptions if the input JSON does not conform to the expected types. By disabling exceptions and falling back to default null or zero values, it improves data ingestion robustness and prevents failures due to invalid typed JSON paths.How to use it
Enable this feature by settingtype_json_skip_invalid_typed_paths = 1 in your ClickHouse settings before performing inserts or type casts to the JSON type. This will cause invalid typed paths in JSON inputs to be converted to null or zero values instead of raising exceptions.