How to unload One BIG table (containing 200 - 300 Million records) into multiple files

edited May 2019 in General Discussion

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?

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file