-
Notifications
You must be signed in to change notification settings - Fork 5.8k
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.
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
Support for table partition #7907
Comments
@tiancaiamao Good job! |
Is there any public design doc of
|
There should be a design proposal, I'll push one later.
The partition syntax should be totally compatible with MySQL, while there are some limitations.
It depends. We plan to do it step by step, "partition by range" first, then "partition by hash"...
No. There is no plan for namespace now. |
i want to do this "Drop index operation on hash partitioned table" |
I want to take the "Implement insert and replace for hash partitioned table" |
I want to do this "Implement select for hash partitioned table" |
Is there a task to colocate partitions from different tables together so you can have single-partition transactions over multiple tables if they share partition-keys ? |
Hi, here We focus primary on MySQL compatibility, not clever tricks in NoSQL discussed there #7392 @ddorian |
I want to |
We can still add more tests to verify it works @crazycs520 |
@tiancaiamao thank you, I would like to have a try. please guide me when I meet some problems~ |
Alter table truncate partition is done #8624 |
There is a project for the table partition feature.
In fact, "partition by range" is nearly done, but it's regretful that the progress was traced in our inner project management tools.
Now, it's time for "partition by hash", and this issue is fired to discuss & trace the progress, in a collaborative way.
insert
andreplace
for hash partitioned tableselect
for hash partitioned tabledelete
for hash partitioned tableupdate
for hash partitioned tableMost of those are trivial. For example, implement
insert
needs to changepartitionedTable.AddRecord
, thelocatePartiiotn()
function should adapt to hash partition. Partition prunning probably can't work on "partition by hash", so implementselect
just change theDataSource
toUnionAll
.The text was updated successfully, but these errors were encountered: