JSON 형식 공통 설정
JSON 형식 공통 설정 (format settings)
이 페이지에서는 모든 JSON 형식에 공통으로 적용되는 형식 설정을 다뤄요. JSON 입력 형식의 파싱 동작과 출력 형식의 직렬화 방식을 제어하는 다양한 설정이 있습니다.
출처: 문서
본문
여기에서 모든 JSON 형식에 공통인 형식 설정을 찾아볼 수 있어요.
| 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 or bigger integers in JSON output format. | false | |
| 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. |