Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Question
Hi all. I gotta admit that Vertica has a great utility on move/copy partition. I just wonder if there is any way I can move/copy the partitions across cluster with the same DDL of table. Thank you very much.
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
What do you mean by "...same DDL of table"?
If you mean to copy the table (same DDL) along will all partitioned data, just use a COPY_TABLE...
See:
https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/Functions/VerticaFunctions/COPY_TABLE.htm
@terryhines not sure if you are looking for vertica function like COPY_PARTITIONS_TO_TABLE or MOVE_PARTITIONS_TO_TABLE.