We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Swap Partitions in Vertica 7 — Vertica Forum

Swap Partitions in Vertica 7

I have swapped partitions between tables ( table1 and table2 ) using SWAP_PARTITIONS_BETWEEN_TABLES . If I want to undo this , can I re execute the swap partitions between the two tables again , so that the data will be in place as it was before swapping the partitions.

Answers

  • Yes, assuming both tables still meet the criteria for swapping and no changes after the initial swap.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file