Convert Parquet to JSON Lines with Python
Run this Python script locally with Apache Arrow. The script reads your local file rather than sending it to this website.
Before you start
- Install Python 3 and create an isolated environment using the commands below.
- Place input.parquet in your working folder. Use a new output filename and keep the original.
- Save the Python code as task.py. On macOS/Linux run .venv/bin/python task.py; on Windows PowerShell run .venv\Scripts\python.exe task.py.
python3 -m venv .venv
.venv/bin/python -m pip install pyarrowpy -m venv .venv
.venv\Scripts\python.exe -m pip install pyarrowimport pyarrow.parquet as pq
table = pq.read_table("input.parquet")
import json
with open("output.jsonl", "w", encoding="utf-8") as output:
for row in table.to_pylist():
output.write(json.dumps(row, ensure_ascii=False, default=str) + "\n")
print("Saved output.jsonl")Limits and output
- These examples load the complete table in memory. Use small representative files first; use an explicit Arrow schema when inferred types do not match your intended values.
- The CLI/library examples use their own type mappings, which can differ from this website’s text-column conversion. Keep the source and compare nulls, identifiers, timestamps, decimals and nested values.
- Dates, decimals and other values not directly supported by Python JSON become strings. JSON integers remain numbers, but downstream JavaScript tools may round large integers.
Documentation: Apache Arrow Parquet documentation