I currently have a hypertable that is partitioned only by time
and I want to add an extra dimension e.g. account_id
.
My timescaledb version is 2.8.1
and reading through the docs, I found this:
You can only execute this add_dimension command on an empty hypertable.
My hypertable is not empty.
So, is there a way to add a dimension to an existing hypertable?
If so, then how?