Feature
This view displays the metadata of table groups of all tenants in the sys tenant, especially the partition information of the table groups.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| TABLEGROUP_NAME | varchar(128) | NO | The name of the table group. |
| PARTITIONING_TYPE | varchar(13) | NO | The partitioning type of the partitioned table group. Valid values: NONE: non-partitioningHASH: HASH partitioning (with a single partitioning key)KEY: KEY partitioningRANGE: RANGE partitioning (with a single partitioning key)RANGE COLUMNS: RANGE COLUMNS partitioningLIST: LIST partitioning (with a single partitioning key)LIST COLUMNS: LIST COLUMNS partitioningUNKNOWN: an unknown type |
| SUBPARTITIONING_TYPE | varchar(13) | NO | The subpartitioning type of the partitioned table group. Valid values: NONE: non-subpartitioningHASH: HASH partitioning (with a single partitioning key)KEY: KEY partitioningRANGE: RANGE partitioning (with a single partitioning key)RANGE COLUMNS: RANGE COLUMNS partitioningLIST: LIST partitioning (with a single partitioning key)LIST COLUMNS: LIST COLUMNS partitioningUNKNOWN: an unknown type |
| PARTITION_COUNT | bigint(20) | NO | The number of partitions in the partitioned table group. For a non-partitioned table group, the value is NULL. |
| DEF_SUBPARTITION_COUNT | bigint(0) | NO | The number of subpartitions in the partitioned table group. For a non-subpartitioned table group, the value is NULL. |
| PARTITIONING_KEY_COUNT | bigint(20) | NO | The number of partitioning keys for the partitioned table group. For a non-partitioned table group, the value is NULL. |
| SUBPARTITIONING_KEY_COUNT | bigint(20) | NO | The number of subpartitioning keys for the partitioned table group. For a non-subpartitioned table group, the value is NULL. |