We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Multiple Parquets for One Table — Vertica Forum

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.