Note
This view is available starting with V4.0.0.
Overview
Displays the meta information of a table group, mainly its partition information.
Note
Starting from V4.2.0, the partition attribute fields in this view will no longer have meaning and are uniformly displayed as NONE or NULL.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| TABLEGROUP_NAME | varchar(128) | NO | Table group name |
| PARTITIONING_TYPE | varchar(13) | NO | Partition type of a partitioned table group's partition:
NoteThis field is |
| SUBPARTITIONING_TYPE | varchar(13) | NO | Partition type of a subpartition of a partitioned table group:
NoteStarting from V4.2.0, the value of this field is |
| PARTITION_COUNT | bigint(0) | NO | The value isNULL |
| DEF_SUBPARTITION_COUNT | bigint(0) | NO | The value isNULL |
| PARTITIONING_KEY_COUNT | bigint(0) | NO | The value isNULL |
| SUBPARTITIONING_KEY_COUNT | bigint(0) | NO | The value isNULL |
| SHARDING | varchar(20) | NO | The SHARDING attribute of the table group. Valid values:
NoteThis field is available starting with V4.2.0. |
| SCOPE | varchar(20) | NO | Table group'sSCOPEAttribute. Valid values:
NoteFor V4.4.2, this field is available starting with V4.4.2 BP1. |