Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

UCP: Exchanging Partitions with tables #15005

Closed
tiancaiamao opened this issue Feb 28, 2020 · 2 comments · Fixed by #17149
Closed

UCP: Exchanging Partitions with tables #15005

tiancaiamao opened this issue Feb 28, 2020 · 2 comments · Fixed by #17149
Labels
feature/accepted This feature request is accepted by product managers sig/sql-infra SIG: SQL Infra type/feature-request Categorizes issue or PR as related to a new feature.

Comments

@tiancaiamao
Copy link
Contributor

tiancaiamao commented Feb 28, 2020 •
edited
Loading

Description

The ALTER TABLE ... EXCHANGE PARTITION statement allows a user to exchange partitions with tables. See the MySQL documentation for the detail usage.

A possible implementation might be exchanging the DDL meta information, no data movement is involved.

The relatively difficult part is keeping this change atomic, the basic knowledge about DDL is required.

Other trivial parts are checking the table schema identical and handling nonmatching rows.

Score

2530

Mentor(s)

Contact the mentors: #tidb-challenge-program channel in TiDB Community Slack Workspace

Recommended Skills

  • Golang
  • DDL

Learning Materials
@tiancaiamao tiancaiamao added the type/enhancement The issue or PR belongs to an enhancement. label Feb 28, 2020
@tiancaiamao tiancaiamao added challenge-program-2 type/new-feature and removed type/enhancement The issue or PR belongs to an enhancement. labels Feb 28, 2020
@tiancaiamao tiancaiamao mentioned this issue Feb 28, 2020
Closed
@zimulala zimulala added sig/sql-infra SIG: SQL Infra and removed component/DDL1 labels Mar 4, 2020
@zz-jason zz-jason added type/feature-request Categorizes issue or PR as related to a new feature. and removed type/new-feature labels Apr 3, 2020
@zhaox1n
Copy link
Contributor

zhaox1n commented May 6, 2020

/pick-up-challenge

@sre-bot
Copy link
Contributor

sre-bot commented May 6, 2020

@zhaox1n pick up issue success

@zhaox1n zhaox1n mentioned this issue May 12, 2020
Merged
@tiancaiamao tiancaiamao linked a pull request Jun 1, 2020 that will close this issue
ddl: Support exchange partition #17149
Merged
@zz-jason zz-jason added the feature/accepted This feature request is accepted by product managers label Jul 29, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
feature/accepted This feature request is accepted by product managers sig/sql-infra SIG: SQL Infra type/feature-request Categorizes issue or PR as related to a new feature.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

ddl: Support exchange partition
5 participants
@tiancaiamao @zimulala @zz-jason @zhaox1n @sre-bot