Options

Multiple Parquets for One Table

jzhangjzhang Vertica Customer
edited March 2023 in General Discussion

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.

This discussion has been closed.