Overview
Displays the meta information of a table group, mainly its partition information.
Note
The partition attribute fields in this view 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:
NoteThe value of this field is |
| SUBPARTITIONING_TYPE | varchar(13) | NO | Partition types of subpartitions in a partitioned table group:
NoteThe value of this field is |
| PARTITION_COUNT | bigint(20) | NO | The value is NULL |
| DEF_SUBPARTITION_COUNT | bigint(0) | NO | This 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:
|
Sample query
Create a table group named
tblgroup1.obclient [test]> CREATE TABLEGROUP tblgroup1 SHARDING = 'PARTITION';View the SHARDING attribute of the table group
tblgroup1.obclient [test]> SELECT TABLEGROUP_NAME, SHARDING FROM oceanbase.DBA_OB_TABLEGROUPS WHERE tablegroup_name = 'tblgroup1';The query result is as follows:
+-----------------+-----------+ | TABLEGROUP_NAME | SHARDING | +-----------------+-----------+ | tblgroup1 | PARTITION | +-----------------+-----------+ 1 row in set