Help... ROLLBACK 7976: Add column with default subquery is not supported for unsegmented projection
I have done the same as on this post:
and when I alter the micky table on my db and giving this command:
ALTER TABLE mickey
ADD months_worked INTEGER DEFAULT(SELECT months_worked FROM helper WHERE id=mickey.id);
This is what I get:
ROLLBACK 7976: Add column with default subquery is not supported for unsegmented projections
DETAIL: Projection "spins_DBD_15_rep_test_ittai_3" is unsegmented and is either super projection or specified in the projection list
how can I workaround that?
I am working on Vertica 9.3 version.
Please help me!