SysTools Parquet Splitter Software: Step-by-Step Guide to Break Parquet Files

Effective steps to break large .parquet files into smaller chunks depending on their Size, Record Count, or Column Names.

STEP 1

Install and run SysTools Parquet Splitter Tool.

open file splitter

STEP 2

The tool offers four modes to browse files:

  • Add File(s): To add .parquet files manually in the software.
  • Add Folder(s): To add a complete folder for the split process.
  • Remove: To remove selected .parquet files from the software panel.
  • Remove All: To remove all loaded files from the software panel.

browsing options

STEP 3

Click on Add Files button to load .parquet files for the split process.

add files

STEP 4

Browse the required files to proceed with the file split operation.

browse-files

STEP 5

Next, the tool will display the loaded files in the panel. If there are files you don’t need to split, you can simply click on the file to deselect it.

preview files

STEP 6

Click on the Next Button to move forward with the Parquet file split.

split parquet files

STEP 7

The Split Options Window will open. The tool offers three effective Split Modes:

  • Split by Records: To split Parquet Files based on Record Count specified.
  • Split by Size: To split the files based on desired sizes.
  • Split by Columns: Allows splitting .parquet tables by specified column names.

parquet split

STEP 8

Select Split By Record Count option if you wish to split the .parquet files by the number of records in each file.

Next, set the number of records for file split. The tool allows a range from 10 Records to 1 Million Records (10,00,000 records) per file.

export option

STEP 9

Then, select the destination folder to save the resultant split files. The tool saves files on the Desktop as a default location.

browse destination

STEP 10

Click on the Split Button to begin the Parquet File split process.

click on split

STEP 11

Once the Parquet File split process is completed, a pop-up message for Split Process Completion will be displayed.

split successful

STEP 12

After the split process is completed, the tool offers a split status report with Total File Count, Success File Count, Failed File Count for future analysis for users.

Also, the users can save these reports on their devices.

export status

RESULTANT DATA

Once the split process is finished, you can verify the resultant data in the specified destination.

resultant files

STEP 8

Select Split By Size option to split the .parquet files by the size specified for each resultant file.

Next, set the size for the file. The tool offers sizes in MB and GB, and offers the size range from 1MB to 10 GB for file split.

split by size

STEP 9

Then, browse the destination folder to save the resultant split files. If no destination chosen, the tool will save the resultant files on the Desktop as a default location.

choose destination

STEP 10

Click on the Split Button to begin the Parquet File split process.

click on split

STEP 11

Once the Parquet File split process is completed, a pop-up message for Split Process Completion will be displayed.

split success

STEP 12

After the split process is completed, the tool offers a split status report for future analysis for users. Also, the users can save these reports on their devices.

split status report

RESULTANT DATA

In the destination folder, check the .parquet files split by size.

resultant data

STEP 8

Select Split By Column option to split the .parquet files by the specified column names.

choose csv format

STEP 9

Next, select the column names from the loaded .parquet files. With the tool, users can select the column names from the pop up window with the column names.

choose columns

STEP 10

Then, browse the destination folder to save the resultant split files. If no destination chosen, The tool will save the resultant files on the Desktop as a default location.

choose destination

STEP 11

Click on the Split Button to begin the Parquet File split process.

click on split

STEP 12

After the split process is completed, the tool offers a split status report for future analysis for users. Also, the users can save these reports on their devices.

progress status

RESULTANT DATA

In the destination folder, check the resultant .parquet files split by column names.

resultant data

Free Download Parquet Splitter Software Download Now