cockroachdb/cockroach

sql: support CREATE TABLE ... AS ... PARTITION BY

Open

#20178 opened on Nov 20, 2017

View on GitHub
 (7 comments) (0 reactions) (0 assignees)Go (32,150 stars) (4,124 forks)batch import
A-partitioningA-schema-changesC-enhancementT-sql-foundationsgood first issue

Description

Identified as missing by q/a buddy

Jira issue: CRDB-5940

Epic CRDB-45396

Contributor guide

Tech stack
gopostgresql
Domain
databasebackend
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
5
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
over 1 week
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
unclear
Prerequisites
understanding of SQL CREATE TABLE syntaxfamiliarity with CockroachDB partitioning
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
10
Research direction
Investigate the existing implementation of CREATE TABLE in CockroachDB (likely in pkg/sql/parser and pkg/sql/plan). Look for how PARTITION BY is handled in other contexts (e.g., CREATE INDEX). Review Jira CRDB 5940 and Epic CRDB 45396 for design decisions. Check comments on issue #20178 for any prior discussion or partial work.