How to savely drop a column involved in a projection
I want to drop a column that is part of a primary key and involved in a projection. Clearly, I have to drop the constraints first and define a new primary key. But when I try to drop the projection I get an error: "No up-to-date super projection left on the anchor table of projection X_super".
Also also tried something like
ALTER TABLE X DROP CONSTRAINT pk; CREATE PROJECTION X_p1 as select * FROM X UNSEGMENTED ALL NODES; SELECT START_REFRESH(); SELECT MAKE_AHM_NOW(); ALTER TABLE X DROP COLUMN col; ALTER TABLE X ADD CONSTRAINT pk PRIMARY KEY (other_col) ENABLED;
That works sometime, but not always.
Is there a robsut way to do this?