Convert PARQUET to SQLITE

Turn PARQUET files into SQLITE. A SQLite database with one table named data holding every row, with numbers and text typed.

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 in a SQLite table.One table named data holds every row, with numbers and text typed.

  1. What you get

    A SQLite database in one file. It has a single table named data, and every row of the Parquet file goes into it.

    Numbers and text keep their types, so you can query the columns right away.

  2. How other values are stored

    Lists, structs and maps are stored as text, such as [20.1, 40.2]. Times with a time zone are stored as text in UTC. Binary values are stored as blobs.

    If you later need the data back in a columnar file, SQLITE to PARQUET goes the other way.

  3. When it stops

    If the file cannot be parsed, the conversion stops with input_corrupted. This code means the Parquet file could not be read as a Parquet file.

PARQUET and SQLITE.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 · SQLITE

SQLite Database

A whole relational database in one file. Tables, indexes and views.

Extensions
.sqlite .sqlite3 .db
MIME type
application/vnd.sqlite3
Kind
Text and data

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

terminal
$ cv convert report.parquet report.sqlite
$ cv convert report.parquet report.sqlite

Questions.What people ask about PARQUET to SQLITE.

01OF 04

One. It is named data and holds every row.

As text, such as [20.1, 40.2]. Structs are stored as text too.

They are stored as text in UTC.

Yes. Binary values are stored as blobs.

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