Purpose
The oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS view provides the subpartitioning information of the partitioned table groups of all tenants in the sys tenant.
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. |
| 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 a subpartition of the table group. |
| HIGH_VALUE | varchar(4096) | NO | The subpartitioning key value for the partitioned table group. For a HASH- or KEY-subpartitioned table group, the value is NULL. |
| HIGH_VALUE_LENGTH | bigint(20) | NO | The character length of the partitioning key value when HIGH_VALUE is valid. |
| PARTITION_POSITION | bigint(20) | NO | The number of the partition corresponding to the subpartition in the table group, which starts from 1. If the partitioning type is: HIGH_VALUE.PARTITION_POSITION minus 1 indicates the partitioning key value % the number of partitions. |
| SUBPARTITION_POSITION | bigint(20) | NO | The number of the partition corresponding to the subpartition in the table group, which starts from 1. If the subpartitioning type is: HIGH_VALUE.SUBPARTITION_POSITION minus 1 indicates the subpartitioning key value % the number of subpartitions corresponding to the partition. |