Note
This view is available starting with V4.0.0.
Purpose
This view displays the metadata of all table groups of all tenants in the sys tenant. It mainly displays the partitioning information of the table groups.
Note
Starting from V4.2.0, the partitioning attribute fields in this view will be displayed as NONE or NULL.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| 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 field 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 field is |
| PARTITION_COUNT | bigint(20) | NO | The value is NULL. |
| DEF_SUBPARTITION_COUNT | bigint(0) | NO | The value is NULL. |
| PARTITIONING_KEY_COUNT | bigint(20) | NO | The value is NULL. |
| SUBPARTITIONING_KEY_COUNT | bigint(20) | NO | The value is NULL. |
| SHARDING | varchar(20) | NO | The SHARDING attribute of the table group. Valid values:
NoteThis field is available starting from V4.2.0. |
Sample query
Create a table group named
tblgroup1.obclient [test]> CREATE TABLEGROUP tblgroup1 SHARDING = 'PARTITION';Query the SHARDING attribute of the
tblgroup1table group.obclient [test]> SELECT TABLEGROUP_NAME, SHARDING FROM oceanbase.CDB_OB_TABLEGROUPS WHERE tablegroup_name = 'tblgroup1';The query result is as follows:
+-----------------+-----------+ | TABLEGROUP_NAME | SHARDING | +-----------------+-----------+ | tblgroup1 | PARTITION | +-----------------+-----------+ 1 row in set