Skip to main content

Alter table column datatype is not allowed when one of the vertica nodes are down ?

  • June 15, 2016
  • 3 replies
  • 17 views

Suhrid_R__Ghosh
Forum|alt.badge.img+1

 

Hello,

 

         Why alter table column datatype is not allowed when one of the vertica nodes are down ?

 

Thanks,

Suhrid Ghosh

3 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • June 15, 2016

Hi,

 

   With respect to current architecture of vertica, alter table column data type is not allowed. But how ever there is an enhance request which is being worked on for this issue


Adrian_Oprea_1
Forum|alt.badge.img+1
  • Participating Frequently
  • June 16, 2016

  Changes cannot be propagated to the entire cluster so that is why you might not be able to make any changes while a node is down.

 

  To workaround this create a new table with the desired definition, or bring the down node back online before.

 

 


Suhrid_R__Ghosh
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • June 16, 2016

Thanks Sruthi & Adrian for the update ...