Convert TSV to PARQUET
Turn TSV files into PARQUET. A Parquet table with a header from the first row and its columns typed from the values, such as integers, decimals, dates and text.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop TSV files on the dialor turn it to pick what to do
A typed Parquet table from your TSV.Columns get types from their values, and the first row becomes the header.
What you get
One Parquet file with a header taken from the first row. Each column is typed from the values in it, such as integers, decimals, dates and text.
Parquet is a columnar format. Typed columns are what make it useful for analytics, where a table is scanned column by column.
How columns are typed
A column that mixes numbers and text further down is kept as text. The values are not dropped or changed to fit a number type.
If the first row is data rather than names, turn off Header row. The columns are then named column0, column1 and so on.
TSV and PARQUET.What each format is, and the options this conversion takes.
- 01 · header
Header row
Whether the first row holds the column names rather than data.
default true
The formats
Tab-Separated Values
Tab-separated values.
- Extensions
- .tsv .tab
- MIME type
- text
/tab -separated -values - Kind
- Text and data
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
In your code.The same TSV to PARQUET conversion through the API, for your app or your agent.
$ cv convert sheet.tsv sheet.parquet$ cv convert sheet.tsv sheet.parquetQuestions.What people ask about TSV to PARQUET.
Yes. Header row is on by default, so the first row names the columns. Turn it off if the first row holds data.
They are named column0, column1 and so on.
It is kept as text. This applies when text appears further down in a column that otherwise holds numbers.
Yes. PARQUET to TSV converts it back to tab-separated text.