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_SUBPARTITIONS view displays the subpartitioning 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. |
| PARTITION_NAME | varchar(64) | NO | The name of the partition corresponding to the subpartition of the table group. |
| SUBPARTITION_NAME | varchar(64) | NO | The name of the subpartition of the table group. |
| 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) | NO | The value of this column is NULL. |
| SUBPARTITION_POSITION | bigint(20) | NO | The value of this column is NULL. |