Skip to main content
Skip to main content
Edit this page

JSONColumns

InputOutputAlias
✔✔

Description​

Tip

The output of the JSONColumns* formats provides the ClickHouse field name and then the content of each row in the table for that field; visually, the data is rotated 90 degrees to the left.

In this format, all data is represented as a single JSON Object.

Note

The JSONColumns format buffers all data in memory and then outputs it as a single block, so, it can lead to high memory consumption.

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 JSONColumns format:

The output will be in JSON format:

Format settings​

During import, columns with unknown names will be skipped if setting input_format_skip_unknown_fields is set to 1. Columns that are not present in the block will be filled with default values (you can use the input_format_defaults_for_omitted_fields setting here)