Convert PARQUET to JSONL

Turn PARQUET files into JSONL. One JSON object per line for each row; numbers, booleans and nulls stay typed, and lists, structs and maps stay nested.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop PARQUET files on the dialor turn it to pick what to do

Parquet rows as JSON lines.Each row becomes one JSON object on its own line, in a single file.

  1. What you get

    One JSONL file with one JSON object per line, one line for each row in the PARQUET file. The result is a single file.

    Numbers, booleans and nulls stay typed. A number is written as a number, not as text, and a null stays null.

  2. Nested values

    Lists, structs and maps stay nested. They are not flattened into separate columns or turned into strings.

  3. What changes

    Binary values become escaped text. Times with a time zone are written in UTC.

  4. When it stops

    A file that cannot be parsed stops the conversion with input_corrupted. This means the PARQUET file itself could not be read.

PARQUET and JSONL.What each format is.

The formats

From · PARQUET

Parquet

The columnar data format of analytics. Compressed, typed and fast to scan.

Extensions
.parquet .pq
MIME type
application/vnd.apache.parquet
Kind
Text and data
To · JSONL

JSON Lines

JSON Lines, one JSON object per line, the format of logs and datasets.

Extensions
.jsonl .ndjson
MIME type
application/jsonl
Kind
Text and data

In your code.The same PARQUET to JSONL conversion through the API, for your app or your agent.

terminal
$ cv convert report.parquet report.jsonl
$ cv convert report.parquet report.jsonl

Questions.What people ask about PARQUET to JSONL.

01OF 04

One file. Every row of the PARQUET file becomes a line in that file.

Yes. Numbers, booleans and nulls stay typed in the JSON objects.

Lists, structs and maps stay nested inside each object.

Yes. Use JSONL to PARQUET for the reverse conversion.

More conversions.Other ways in and out of PARQUET and JSONL.