support `COALESCE PARTITION` for hash partitioned table

[tiancaiamao]

Description

The 'ALTER TABLE ... COALESCE PARTITION' statement can adjust the partition count.

mysql> CREATE TABLE clients_lk (
    ->     id INT,
    ->     fname VARCHAR(30),
    ->     lname VARCHAR(30),
    ->     signed DATE
    -> )
    -> PARTITION BY LINEAR KEY(signed)
    -> PARTITIONS 12;
Query OK, 0 rows affected (0.03 sec)

mysql> ALTER TABLE clients_lk COALESCE PARTITION 4;
Query OK, 0 rows affected (0.06 sec)
Records: 0  Duplicates: 0  Warnings: 0

Consider #14999 and #15000 before taking this task, as ALTER TABLE ... COALESCE PARTITION is less frequent in practical use.

Score

9885

Mentor(s)

• @tiancaiamao

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

Recommended Skills

• Golang

Learning Materials

• MySQL document about partitioning management
• Chinese: TiDB 精选技术讲解文章
• English: Awesome-Database-Learning