Rebalance table

[Timbo]

Hi,
Is there a "rebalance" table command rather than the "rebalance_cluster". We have added a couple of nodes to the cluster and want to rebalance the data on a table by table basis. I was planning on dropping and recreateing each projection on a table, but this seams very exteme as a way of populating the new nodes.

Regards
Tim

[jpcavanaugh]

Tim - when you add nodes vertica creates new projections that are inclusive of the new nodes, populates them and then drops the old projections. If you want to do this table by table you can by adding new projections with the same definition (new name) and then dropping the old projections. If you want detailed help, let me know!

[Timbo]

Thanks for the reply, that is what we are doing, but it would be nice if the rebalance functionality could be written at table level.

[jpcavanaugh]

Did you write a script to do it? I was thinking of doing that and uploading it to the vertica github repository.