Note
- The concept of partitions no longer exists for table groups. This view is no longer used. Users can query it, but the result will be empty.
- You can query table group information through the CDB_OB_TABLEGROUPS view. For more details about table groups, see About table groups.
Overview
The system tenant displays the subpartition information for all tenant's partitioned table groups.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| TABLEGROUP_NAME | varchar(128) | NO | TABLEGROUP Name |
| PARTITION_NAME | varchar(64) | NO | The name of the partition to which the subpartition belongs. |
| SUBPARTITION_NAME | varchar(64) | NO | Subpartition name of the table group |
| HIGH_VALUE | varchar(4096) | NO | The value is NULL |
| HIGH_VALUE_LENGTH | bigint(20) | NO | The value is NULL |
| PARTITION_POSITION | bigint(20) | NO | The value is NULL |
| SUBPARTITION_POSITION | bigint(20) | NO | This value is NULL. |