citusdata / citusdata/citus

Nested partitioning doesn't allow to distribute a shard in Citus

Open
#8,013 2 comments 0 reactions 0 assignees View on GitHub
Support
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.