Skip to main content
Skip to main content

JSONLines

InputOutputAlias
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.

Format Settings