Skip to main content
Question

Question

  • March 23, 2021
  • 2 replies
  • 9 views

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.

2 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • March 23, 2021

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
Forum|alt.badge.img
  • Participating Frequently
  • March 23, 2021

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