Format Settings For JSON

List of format settings for the JSON format

On this page you can find format settings common to all JSON formats.

Setting	Description	Default	Note
input_format_import_nested_json	Map nested JSON data to nested tables (it works for JSONEachRow format).	false
input_format_json_read_bools_as_numbers	Allow to parse bools as numbers in JSON input formats.	true
input_format_json_read_bools_as_strings	Allow to parse bools as strings in JSON input formats.	true
input_format_json_read_numbers_as_strings	Allow to parse numbers as strings in JSON input formats.	true
input_format_json_read_arrays_as_strings	Allow to parse JSON arrays as strings in JSON input formats.	true
input_format_json_read_objects_as_strings	Allow to parse JSON objects as strings in JSON input formats.	true
input_format_json_named_tuples_as_objects	Parse named tuple columns as JSON objects.	true
input_format_json_try_infer_numbers_from_strings	Try to infer numbers from string fields while schema inference.	false
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	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	Insert default values for missing elements in JSON object while parsing named tuple.	true
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	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	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	Treat empty fields in JSON input as default values.	false	For complex default expressions input_format_defaults_for_omitted_fields must be enabled too.
output_format_json_quote_64bit_integers	Controls quoting of 64-bit integers in JSON output format.	true
output_format_json_quote_64bit_floats	Controls quoting of 64-bit floats in JSON output format.	false
output_format_json_quote_denormals	Enables ‘+nan’, ‘-nan’, ‘+inf’, ‘-inf’ outputs in JSON output format.	false
output_format_json_quote_decimals	Controls quoting of decimals in JSON output format.	false
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	Serialize named tuple columns as JSON objects.	true
output_format_json_array_of_rows	Output a JSON array of all rows in JSONEachRow(Compact) format.	false
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.