Handling Multiple Partitions in One ROS Container

Occasionally, a ROS container contains rows that belong to more than one partition. For example, in some cases refresh and recovery operations can generate ROS containers with mixed partitions. In general, Vertica segregates data from different partitions in different ROS containers, but exceptions can occur. This is generally true only in a database that was created with an early version of Vertica.

If a ROS container has data from multiple partitions, DROP_PARTITION executes as follows:

  1. If the WOS contains table data, forces a moveout operation.
  2. Divides the ROS container data among two containers:

    • One container holds the data that belongs to the partition to drop.
    • The second container holds the remaining partitions
  3. Drops the specified partition.