Multiple Parquets for One Table
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.