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


Rebalancing tables — Vertica Forum

Rebalancing tables

bmurrellbmurrell Community Edition User

I have 2 Production Vertica databases.
They both had nodes added to a few years ago.
I'm running the following SQL : -
select * from v_monitor.rebalance_table_status where to_transfer_bytes > 0 order by to_transfer_bytes

In 1 database this is empty, but the other has many entries. If I look at get_projection_segments for those projections, the output is .
What does that mean ?
Does it mean the metadata is corrupt?
Are queries not filtering correctly based on the hash segmentation?

Tagged:

Answers

  • SruthiASruthiA Administrator

    it is possible that you had added nodes in one database and not in another database. Please open a support ticket and share scrutinizes from 2 clusters

Leave a Comment

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