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 (note that it doesn't impact formats JSON/JSONCompact/JSONColumnsWithMetadata, they always validate utf8). `false`  | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |