The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
How to unload One BIG table (containing 200 - 300 Million records) into multiple files
We have requirement to unload One BIG table in Vertica (containing 200 - 300 Million records) into multiple files using one command.
What's the utility I should use to achieve this functionality like in Teradata there is TPT script which creates multiple parallel connection to export data in parallel. Is there something like that in Vertica?
0
Comments
Hi,
There used to be a user defined function - ParallelExport - on the market place (unsupported) not sure if it's still available...
But, you can use export to parquet, it's quite fast: https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Statements/EXPORTTOPARQUET.htm?zoom_highlight=export to parquet
Chaima