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.
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.
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.
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
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
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.
$ cv convert report.parquet report.sqlite$ cv convert report.parquet report.sqliteQuestions.What people ask about PARQUET to SQLITE.
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.