search

cockroach-staging / hello-world

0 stars 0 forks source link

S163: As a developer, I want to be able to name the partition scheme for a partition table and reuse it across multiple other tables so that I can save time in partitioning my tables and so that I can avoid user error. For example, if I had a table t (... #619

Open exalate-issue-sync[bot] opened 4 years ago

exalate-issue-sync[bot] commented 4 years ago

As a developer, I want to be able to name the partition scheme for a partition table and reuse it across multiple other tables so that I can save time in partitioning my tables and so that I can avoid user error. For example, if I had a table t (region, id) that was partitioned into “US” and “EU”, I’d like to be able to apply that partitioning to other tables that are also prefixed by region.

exalate-issue-sync[bot] commented 4 years ago

Rachel Casali commented: ===Proposed Solution=== A new syntax of PARTITION LIKE table as tracked in #20886. This solution provides for one canonical place to set partitions.
We rejected the option of pursuing a CASCADE like approach.