Note
This view is available starting with V4.0.0.
Purpose
This view displays the metadata of a table group, including the partition information.
Note
Starting from V4.2.0, the partition attribute fields in this view will no longer have meaning and will be uniformly displayed as NONE or NULL.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TABLEGROUP_NAME | varchar(128) | NO | The name of the table group. |
| PARTITIONING_TYPE | varchar(13) | NO | The partitioning type of the primary partitions of the table group. Valid values:
NoteStarting from V4.2.0, the value of this column is |
| SUBPARTITIONING_TYPE | varchar(13) | NO | The partitioning type of the subpartitions of the table group. Valid values:
NoteStarting from V4.2.0, the value of this column is |
| PARTITION_COUNT | bigint(0) | NO | The value is NULL. |
| DEF_SUBPARTITION_COUNT | bigint(0) | NO | The value is NULL. |
| PARTITIONING_KEY_COUNT | bigint(0) | NO | The value is NULL. |
| SUBPARTITIONING_KEY_COUNT | bigint(0) | NO | The value is NULL. |
| SHARDING | varchar(10) | NO | The SHARDING attribute of the table group. Valid values:
NoteThis column is available starting from V4.2.0. |
| SCOPE | varchar(20) | NO | The SCOPE attribute of the table group. Valid values:
NoteFor V5.x, this column is available starting from V5.0.1. |
Sample query
Query the attributes of the tblgroup1 table group.
obclient> SELECT * FROM oceanbase.DBA_OB_TABLEGROUPS
WHERE tablegroup_name = 'tblgroup1'\G
The query result is as follows:
*************************** 1. row ***************************
TABLEGROUP_NAME: tblgroup1
PARTITIONING_TYPE: NONE
SUBPARTITIONING_TYPE: NONE
PARTITION_COUNT: NULL
DEF_SUBPARTITION_COUNT: NULL
PARTITIONING_KEY_COUNT: NULL
SUBPARTITIONING_KEY_COUNT: NULL
SHARDING: NONE
SCOPE: ZONE
1 row in set