JSONCompactEachRowWithNamesAndTypes
Input | Output | Alias |
---|---|---|
✔ | ✔ |
Description
Differs from the JSONCompactEachRow
format in that it also prints two header rows with column names and types, similar to the TabSeparatedWithNamesAndTypes format.
Example Usage
Inserting Data
Using a JSON file with the following data, named as football.json
:
Insert the data:
Reading Data
Read data using the JSONCompactEachRowWithNamesAndTypes
format:
The output will be in JSON format:
Format Settings
If setting input_format_with_names_use_header
is set to 1
,
the columns from input data will be mapped to the columns from the table by their names, columns with unknown names will be skipped if setting input_format_skip_unknown_fields is set to 1.
Otherwise, the first row will be skipped.
If setting input_format_with_types_use_header
is set to 1
,
the types from input data will be compared with the types of the corresponding columns from the table. Otherwise, the second row will be skipped.