Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Add columns to projection

Does anyone know of a way to add a column to a projection (that is not a super-projection)?

Or do you always rebuild the entire projection from scratch whenever adding columns?


  • From support I found out that there is currently way to add columns to non-superprojections.

    So I'm more curious in the community feedback about this. If you have a large projection (that is not a super-projection), do you really do full rebuilds when adding columns?
  • What was The way that support advice you to do that ?
  • No real advice about how to work around it.

    But we have entered "adding columns to non-superprojections" as a feature request (VER-30079).

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
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.