Note
- In V4.2.0 and later, table groups no longer support partitions. Therefore, this view is no longer used. You can query this view, but the query result is empty.
- In V4.2.0 and later, you can query information about table groups by using the CDB_OB_TABLEGROUPS view. For more information about table groups, see About table groups.
Purpose
This view displays the information about subpartitions of partitioned table groups in all tenants in the system tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| TABLEGROUP_NAME | varchar(128) | NO | Name of the table group |
| PARTITION_NAME | varchar(64) | NO | Name of the primary partition corresponding to the subpartition of the table group |
| SUBPARTITION_NAME | varchar(64) | NO | Name of the subpartition of the table group |
| HIGH_VALUE | varchar(4096) | NO | This value is NULL. |
| HIGH_VALUE_LENGTH | bigint(20) | NO | This value is NULL. |
| PARTITION_POSITION | bigint(20) | NO | This value is NULL. |
| SUBPARTITION_POSITION | bigint(20) | NO | This value is NULL. |