Line-Delimited JSON Overview
A line-delimited JSON file is a type of aggregate file where each line is a self-contained piece of JSON data, such as an object or array.
Usually, each line of input has similar structure, such as the following:
{"id": "12345","price":8.99, "in-stock": true}
{"id": "67890","price":2.00, "in-stock": false}
However, the JSON data on each line is independent of the other lines, so the lines do not have to contain JSON data of the same “shape”. For example, the following is a valid input file:
{"first": "george", "last": "washington"}
{"id": 12345, "price": 8.99, "in-stock": true}
Given the input shown below, the following command creates 2 JSON documents. Each document contains the data from a single line of input.
$ cat example.json
{"id": "12345","price":8.99, "in-stock": true}
{"id": "67890","price":2.00, "in-stock": false}
# Windows users, see Modifying the Example Commands for Windows
$ mlcp.sh import -host localhost -port 8000 -username user \
-password password -mode local -input_file_path example.json \
-input_file_type delimited_json
The example command creates documents whose contents precisely mirror each of input:
{"id": "12345","price":8.99, "in-stock": true}
{"id": "67890","price":2.00, "in-stock": false}