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?
+2Hi,
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
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
