information_schema.TABLE_PARTITION_INFO_BRIEF provides brief (lightweight) partition information for all user tables in a TDSQL Boundless instance. Compared to information_schema.PARTITIONS, this view only exposes core fields closely related to partition scheduling. This facilitates efficient queries on the partition Schema of base tables by internal components such as the Meta Cluster (MC).Field Name | Type | Description |
TABLE_NAME | VARCHAR(64) | Table name |
TINDEX_ID | INT UNSIGNED | Index ID of the base table (TIndex ID), which globally and uniquely identifies the storage object of a table. |
PARTITION_METHOD | VARCHAR(13) | Primary partitioning method. Valid values: HASH, RANGE, LIST, AUTO, KEY, LINEAR KEY, LINEAR HASH, RANGE COLUMNS, LIST COLUMNS. NULL when the table is not partitioned. |
SUBPARTITION_METHOD | VARCHAR(13) | Subpartitioning method. Its value range is the same as that of PARTITION_METHOD. NULL when subpartitions are not defined for the table. |
PARTITION_EXPRESSION | VARCHAR(2048) | Primary partition expression (UTF-8 encoded). NULL when the table is not partitioned. |
SUBPARTITION_EXPRESSION | TEXT | Subpartition expression (UTF-8 encoded). NULL when subpartitions are not defined for the table. |
PARTITION_NAME | VARCHAR(64) | Primary partition name. NULL when the table is not partitioned. |
PARTITION_ORDINAL_POSITION | INT UNSIGNED | Ordinal position of the primary partition within the table, starting from 1. NULL when the table is not partitioned. |
SUBPARTITION_NAME | VARCHAR(64) | Subpartition name. NULL when subpartitions are not defined for the table. |
SUBPARTITION_ORDINAL_POSITION | INT UNSIGNED | Ordinal position of the subpartition within its primary partition, starting from 1. NULL when subpartitions are not defined for the table. |
PARTITION_TINDEX_ID | INT UNSIGNED | TIndex ID corresponding to the primary partition. NULL when the table is not partitioned. |
SUBPARTITION_TINDEX_ID | BIGINT UNSIGNED | TIndex ID corresponding to the subpartition. NULL when subpartitions are not defined for the table. |
SELECT * FROM information_schema.TABLE_PARTITION_INFO_BRIEF\\G
SELECT TABLE_NAME, PARTITION_METHOD, PARTITION_NAME,PARTITION_ORDINAL_POSITION, PARTITION_TINDEX_IDFROM information_schema.TABLE_PARTITION_INFO_BRIEFWHERE TABLE_NAME = 'orders';
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback