Skip to main content
Question

Multiple Parquets for One Table

  • February 28, 2023
  • 0 replies
  • 3 views

jzhang

I used export to parquet to generate the parquet files for our tables, but some of the tables got multiple parquet files generated. Could anyone help advise how can I generate just one parquet for each table? Thank you! Below is the script I used.

EXPORT TO PARQUET(directory = '/home/dbadmin/tablename') AS SELECT * FROM schema.tablename;

There are two parquet files generated by this script.