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

 

Hello,

 

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

 

Thanks,

Suhrid Ghosh

Comments

  • SruthiASruthiA Employee

    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

  •   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.

     

     

  • Thanks Sruthi & Adrian for the update ...

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.