title_wip

| | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`input_format_json_try_infer_named_tuples_from_objects`](/docs/operations/settings/formats#input_format_json_try_infer_named_tuples_from_objects) Try to infer named tuple from JSON objects during schema inference. `true` |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`input_format_json_infer_incomplete_types_as_strings`](/docs/operations/settings/formats#input_format_json_infer_incomplete_types_as_strings) Use type String for keys that contains only Nulls or empty objects/arrays during schema inference in JSON input formats. `true` |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`input_format_json_defaults_for_missing_elements_in_named_tuple`](/docs/operations/settings/formats#input_format_json_defaults_for_missing_elements_in_named_tuple) Insert default values for missing elements in JSON object while parsing named tuple. `true` |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`input_format_json_ignore_unknown_keys_in_named_tuple`](/docs/operations/settings/formats#input_format_json_ignore_unknown_keys_in_named_tuple) Ignore unknown keys in json object for named tuples. `false` |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`input_format_json_compact_allow_variable_number_of_columns`](/docs/operations/settings/formats#input_format_json_compact_allow_variable_number_of_columns) Allow variable number of columns in JSONCompact/JSONCompactEachRow format, ignore extra columns and use default values on missing columns. `false` |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`input_format_json_throw_on_bad_escape_sequence`](/docs/operations/settings/formats#input_format_json_throw_on_bad_escape_sequence) Throw an exception if JSON string contains bad escape sequence. If disabled, bad escape sequences will remain as is in the data. `true` |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`input_format_json_empty_as_default`](/docs/operations/settings/formats#input_format_json_empty_as_default) Treat empty fields in JSON input as default values. `false` For complex default expressions [input\_format\_defaults\_for\_omitted\_fields](/docs/operations/settings/formats#input_format_defaults_for_omitted_fields) must be enabled too.| [`output_format_json_quote_64bit_integers`](/docs/operations/settings/formats#output_format_json_quote_64bit_integers) Controls quoting of 64-bit integers in JSON output format. `true` |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`output_format_json_quote_64bit_floats`](/docs/operations/settings/formats#output_format_json_quote_64bit_floats) Controls quoting of 64-bit floats in JSON output format. `false` |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`output_format_json_quote_denormals`](/docs/operations/settings/formats#output_format_json_quote_denormals) Enables '+nan', '-nan', '+inf', '-inf' outputs in JSON output format. `false` |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`output_format_json_quote_decimals`](/docs/operations/settings/formats#output_format_json_quote_decimals) Controls quoting of decimals in JSON output format. `false` |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`output_format_json_escape_forward_slashes`](/docs/operations/settings/formats#output_format_json_escape_forward_slashes) Controls escaping forward slashes for string outputs in JSON output format. `true` |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`output_format_json_named_tuples_as_objects`](/docs/operations/settings/formats#output_format_json_named_tuples_as_objects) Serialize named tuple columns as JSON objects. `true` |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | | [`output_format_json_array_of_rows`](/docs/operations/settings/formats#output_format_json_array_of_rows) Output a JSON array of all rows in JSONEachRow(Compact) format. `false` |  |  |  |  | | --- | --- | --- | --- | | [`output_format_json_validate_utf8`](/docs/operations/settings/formats#output_format_json_validate_utf8) Enables validation of UTF-8 sequences in JSON output formats `false` Note that it doesn't impact formats JSON/JSONCompact/JSONColumnsWithMetadata, they always validate utf8. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |