The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
how to remove buddy projection from broken node?
node_name | projection_name | verified_fault_tolerance
v_sspsmaclick_node0005 | for_test_super_b1 | 2
v_sspsmaclick_node0001 | for_test_super_b1 | 2
v_sspsmaclick_node0006 | for_test_super_b1 | 2
node_name | node_state
v_sspsmaclick_node0001 | UP
v_sspsmaclick_node0005 | UP
v_sspsmaclick_node0006 | DOWN
0
Answers
One option is:
Mark broken node ephemeral , create new table as insert select from current table and drop current table;