JSONEachRow
| Input | Output | Alias |
|---|---|---|
| ✔ | ✔ | JSONLines, NDJSON |
Description
In this format, ClickHouse outputs each row as a separated, newline-delimited JSON Object.
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 JSONEachRow format:
The output will be in JSON format:
Importing data columns with unknown names will be skipped if setting input_format_skip_unknown_fields is set to 1.
