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.
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...
@terryhines not sure if you are looking for vertica function like COPY_PARTITIONS_TO_TABLE or MOVE_PARTITIONS_TO_TABLE.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.