Question

terryhines

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.

Jim_Knicely

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

Nimmi_gupta

@terryhines not sure if you are looking for vertica function like COPY_PARTITIONS_TO_TABLE or MOVE_PARTITIONS_TO_TABLE.