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 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 serial number of the partition corresponding to the subpartition of the table group, which starts from 1. Take note of the following points for different partitioning types: LIST or LIST COLUMNS: this value is in a partial ordering relation with the partition creation time.RANGE or RANGE COLUMNS: this value is in a partial ordering relation with HIGH_VALUE.HASH or KEY: PARTITION_POSITION minus 1 indicates the partitioning key value % the number of partitions. |
| SUBPARTITION_POSITION | bigint(20) | NO | The serial number of the subpartition in the corresponding partition of the table group, which starts from 1. Take note of the following points for different subpartitioning types: LIST or LIST COLUMNS: this value is in a partial ordering relation with the partition creation time.RANGE or RANGE COLUMNS: this value is in a partial ordering relation with HIGH_VALUE.HASH or KEY: SUBPARTITION_POSITION minus 1 indicates the subpartitioning key value % the number of subpartitions corresponding to the partition. |