alter table column not supported when one of vertica node is down!! Why???

Moderator: NorbertKrupa

Post Reply
akshathakki
Newbie
Newbie
Posts: 4
Joined: Fri Oct 04, 2013 8:30 am

alter table column not supported when one of vertica node is down!! Why???

Post by akshathakki » Wed Jun 15, 2016 11:38 am

i tried to alter one of column in my existing table (Out of 3, one node was down when i tried this).

wtdaetl=> alter table PRESENTATION.D_BALANCE_DEF_DIMENSION alter column BALANCE_NAME set DATA TYPE VARCHAR(1);
ROLLBACK 5764: Cannot alter the data type of a table column when a node is down

But its giving error saying alter table column not possible when node is down.

Gone through below link:
https://my.vertica.com/docs/7.1.x/HTML/ ... RTABLE.htm

But here no where mentioned the reason for why alter table not supported when node is down?!!!

Why we can't alter table column when node is down? How it effect data recovery when we try to alter column?

Thanks,
Akki

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: alter table column not supported when one of vertica node is down!! Why???

Post by JimKnicely » Thu Sep 22, 2016 2:11 pm

When a node recovers, it needs to get its recovery data from relevant buddy and replicated projections from the up nodes. When you alter a table you are altering the underlying projections. If you were able to alter any columns on the up nodes, how would you expect Vertica to recover the data on the down node where it's projections have not been altered :)
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “General”