The Vertica Forum recently got a makeover! Let us know what you think by filling out this short survey.
Add a column to a table and modify the projection to use the new column in ORDER BY
We are adding a column to the table and plan to use the column in the ORDER BY clause of the projection. We have a single projection on the table. Can I alter the projection adding the new column to the ORDER BY clause, and refresh the projection? I know we could create new projection, refresh the projection and then drop the current projection, but we don't have that much space to do so. Is there a way to do a "in-place" replacement/refresh of the projection?