Rebalancing Data Using SQL Functions

Vertica has three SQL functions for starting and stopping a cluster rebalance. You can call these functions from a script that runs during off-peak hours, rather than manually trigger a rebalance through Administration Tools.

• REBALANCE_CLUSTER rebalances the database cluster synchronously as a session foreground task.
• START_REBALANCE_CLUSTER asynchronously rebalances the database cluster as a background task.
• CANCEL_REBALANCE_CLUSTER stops any rebalance task that is currently in progress or is waiting to execute.