I wanted to know if I have a hypertable with a not null field, I created a continuous aggregation on it and now I want to change the field to nullable.
Can this cause problems as soon as a record with null is added and the view is refreshed?
Hi @davidl, if the continuous aggregates query relies on non-null values, probably it will break.
A safest step would be create a new cagg, refresh it, drop the old one and rename the new one to the old name when it’s done.
If you end up doing some POC share with us as well