JSONCompactColumns
| Input | Output | Alias |
|---|---|---|
| ✔ | ✔ |
Description
In this format, all data is represented as a single JSON Array.
note
The JSONCompactColumns output format buffers all data in memory to output it as a single block which 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 JSONCompactColumns format:
The output will be in JSON format:
Columns that are not present in the block will be filled with default values (you can use input_format_defaults_for_omitted_fields setting here)
