JSONLines
Input | Output | Alias |
---|---|---|
✔ | ✔ | JSONEachRow , 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 JSONLines
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.