Skip to main content
Question

Question

  • Mar 23, 2021 8:46 AM UTC
  • 2 replies
  • 17 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
  • Mar 23, 2021 12:34 PM UTC

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
  • Mar 23, 2021 2:01 PM UTC

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