Note
- Starting from V4.2.0, table groups no longer support partitions, so this view is no longer used. You can query this view, but the query result is empty.
- Starting from V4.2.0, you can query the CDB_OB_TABLEGROUPS view for information about table groups. For more information about table groups, see Table groups.
Purpose
This view displays the subpartition information of all table groups in 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. |
| PARTITION_NAME | varchar(64) | NO | The name of the partition that corresponds to the subpartition in the table group. |
| SUBPARTITION_NAME | varchar(64) | NO | The name of the subpartition in 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 | The value is NULL. |