Purpose
The oceanbase.CDB_OB_TABLEGROUPS view displays the metadata of table groups of all tenants in the sys tenant, especially the partition information of the table groups.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| TABLEGROUP_NAME | varchar(128) | NO | The name of the table group. |
| PARTITIONING_TYPE | varchar(13) | NO | The partitioning type of the partitioned table group. Valid values: NONE: non-partitioningHASH: HASH partitioning (with a single partitioning key)KEY: KEY partitioningRANGE: RANGE partitioning (with a single partitioning key)RANGE COLUMNS: RANGE COLUMNS partitioningLIST: LIST partitioning (with a single partitioning key)LIST COLUMNS: LIST COLUMNS partitioningUNKNOWN: an unknown type
NoteThis column is introduced since OceanBase Database V4.2.0 and is NULL by default. |
| SUBPARTITIONING_TYPE | varchar(13) | NO | The subpartitioning type of the partitioned table group. Valid values: NONE: non-subpartitioningHASH: HASH partitioning (with a single partitioning key)KEY: KEY partitioningRANGE: RANGE partitioning (with a single partitioning key)RANGE COLUMNS: RANGE COLUMNS partitioningLIST: LIST partitioning (with a single partitioning key)LIST COLUMNS: LIST COLUMNS partitioningUNKNOWN: an unknown type
NoteThis column is introduced since OceanBase Database V4.2.0 and is |
| PARTITION_COUNT | bigint(20) | NO | The number of partitions in the partitioned table group. For a non-partitioned table group, the value is NULL. |
| DEF_SUBPARTITION_COUNT | bigint(0) | NO | The number of subpartitions in the partitioned table group. For a non-subpartitioned table group, the value is NULL. |
| PARTITIONING_KEY_COUNT | bigint(20) | NO | The number of partitioning keys for the partitioned table group. For a non-partitioned table group, the value is NULL. |
| SUBPARTITIONING_KEY_COUNT | bigint(20) | NO | The number of subpartitioning keys for the partitioned table group. For a non-subpartitioned table group, the value is NULL. |
| SHARDING | varchar(10) | NO | The attribute of the table group. |