Feature
This view displays the metadata of a table group, mainly the partition information of the table group.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| 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 subpartitioning (with a single subpartitioning key)KEY: KEY subpartitioningRANGE: RANGE subpartitioning (with a single subpartitioning key)RANGE COLUMNS: RANGE COLUMNS subpartitioningLIST: LIST subpartitioning (with a single subpartitioning key)LIST COLUMNS: LIST COLUMNS subpartitioningUNKNOWN: 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. |