Note
- In OceanBase Database V4.2.0 and later, this view is no longer in use because the concept of partition is deprecated in table groups. You can still query this view, but the return result is empty.
- In OceanBase Database V4.2.0 and later, you can query the CDB_OB_TABLEGROUPS view for table groups. For more information about table groups, see Overview.
Purpose
The oceanbase.CDB_OB_TABLEGROUP_PARTITIONS view displays the partitioning information of the partitioned table groups of all tenants in the sys tenant.
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. |
| COMPOSITE | varchar(3) | NO | Indicates whether the table group is subpartitioned. Valid values are YES and NO. |
| PARTITION_NAME | varchar(64) | NO | The name of the partition of the partitioned table group. |
| SUBPARTITION_COUNT | bigint(20) | NO | The value of this column is NULL. |
| HIGH_VALUE | varchar(4096) | NO | The value of this column is NULL. |
| HIGH_VALUE_LENGTH | bigint(20) | NO | The value of this column is NULL. |
| PARTITION_POSITION | bigint(20) unsigned | NO | The value of this column is NULL. |
