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!
Question
terryhines
Vertica Customer
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
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.