Does TiDB plan to support subpartitioned tables?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb 是否计划支持二级分区表

| username: TiDBer_Wal2dh9o

Requirement Feedback
Please clearly and accurately describe the problem scenario, desired behavior, and background information to facilitate timely follow-up by the product team.
[Problem Scenario Involved in the Requirement]
Currently, TiDB only supports single-level partitioning, but the parser defines keywords related to subpartitioning. When is subpartition support planned?

[Expected Desired Behavior]
Compatibility with MySQL subpartition functionality.

[Alternative Solutions]
None.

[Background Information]
Such as which users will benefit from it, and some usage scenarios. Any API design, models, or diagrams would be helpful.
MySQL customers can smoothly migrate to TiDB.

| username: Billmay表妹 | Original post link

You can look forward to it; there might be a chance to add it in versions after 7.5~

| username: Billmay表妹 | Original post link

Compatible starting from 7.4

You can consider versions after v7.5.0~

| username: yixingqingkong | Original post link

Is there an estimated timeline for supporting subpartitions? We are currently selecting a distributed database and are considering migrating from OB to TiDB, but we have a strong requirement for subpartitions.

| username: Billmay表妹 | Original post link

You can keep an eye on the versions after 7.5, but there is no timeline yet. Today, version 7.1.2 is released, so you can install version 7.1.2 first and then upgrade to version 7.5 and later versions when they become available.

| username: Billmay表妹 | Original post link

There is no specific time yet. This feature will be considered after 7.5. It is currently under workload evaluation… You can look forward to the end of the year.

| username: yixingqingkong | Original post link

Got it, thanks. Also, I noticed that many people have a strong demand for global secondary indexes on partitioned tables. Is there a timeline for this?

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.