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.

  1. 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.

  2. 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.

  3. 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.

01OF 04

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.