Nested partitioning doesn't allow to distribute a shard in Citus
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
I use schema-based sharding strategy and Citus 12.1
We have SaaS, so we use schema-per-tenant approach. In our system users often make requests of time series data for period of time for a special source, so our team made a decision to hold time series data in Postgres 16 utilizing a subpartitioning. The first layer of partitions is sliced by "source_id" and a second layer by timestamp "meas_ts".
When I call:
```SELECT citus_schema_distribute('tenant_a');```
I get a error:
```
ERROR: tables in a distributed schema cannot inherit or be inherited
SQL state: XX000
```
If I delete second level of partitioning ```SELECT citus_schema_distribute('tenant_a');``` works well.
Contributor guide
Assessment
This issue has not been assessed yet.