Merge PARQUET files
Join PARQUET files into one, end to end, in the order you add them.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop PARQUET files on the dialor turn it to pick what to do
Several Parquet files, one table.Rows from every file are joined end to end, in the order you add them.
What you get
One Parquet file that holds the rows of every file you add. The files are stacked in the order you add them, so the rows of the first file come first, then the rows of the second, and so on.
Add two or more files. The output is a single file.
How columns line up
Columns are matched by name, not by position. The first file's columns come first. A column that only a later file has is added at the end of the table.
If a file has no column for a name, its cells in that column are left empty.
When types differ
If a column has a different type in different files, it takes a type that holds both. Numbers in one file and text in another become text in the merged column.
Questions.What people ask about merging PARQUET files.
In the order you add the files. The rows of the first file come first, followed by the rows of each later file.
Columns are matched by name. A column that only a later file has is added at the end, and cells for files without that column are left empty.
The column takes a type that holds both. For numbers and text, that type is text.
See every PARQUET conversion for the other conversions that start from or lead to this format.