Currently, I have a set of continuous aggregates, which are as below:
I want to migrate them to hierarchical aggregates, such that data in the underlying hypertable is not lost. At present, I see an option to do as below:
- Create a hierarchical aggregate with a new name.
- Copy data from old hypertable to the new hypertable.
- Drop old aggregate.
However, I do see this as a cumbersome process. Is there a better way to handle this?