Skip to main content
Question

Rebalancing tables

  • April 8, 2024
  • 1 reply
  • 3 views

bmurrell
Forum|alt.badge.img+2

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?

1 reply

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • April 8, 2024

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