Note
- Starting from V4.2.0, table groups no longer have partitions, so this view is no longer used. You can query this view, but the query result is empty.
- For V4.2.0 and later, you can query the CDB_OB_TABLEGROUPS view for information about table groups. For more information about table groups, see About table groups.
Purpose
This view displays the partition information of table groups of all tenants under the sys tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| TABLEGROUP_NAME | varchar(128) | NO | The name of the table group. |
| COMPOSITE | varchar(3) | NO | Indicates whether the partitioned table group is a composite partitioned table group. Valid values: YES and NO. |
| PARTITION_NAME | varchar(64) | NO | The name of the partition of the partitioned table group. |
| SUBPARTITION_COUNT | bigint(20) | NO | This column is reserved and will be NULL. |
| HIGH_VALUE | varchar(4096) | NO | This column is reserved and will be NULL. |
| HIGH_VALUE_LENGTH | bigint(20) | NO | This column is reserved and will be NULL. |
| PARTITION_POSITION | bigint(20) unsigned | NO | This column is reserved and will be NULL. |