Purpose
v$partition displays the metadata about the partitions on the current OBServer node.
Related tables/views
gv$partition
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| tenant_id | bigint(20) | NO | The ID of the tenant. |
| table_id | bigint(20) | NO | The ID of the table. |
| tablegroup_id | bigint(20) | NO | The ID of the table group. |
| partition_id | bigint(20) | NO | The ID of the partition. |
| svr_ip | varchar(32) | NO | The IP address of the OBServer node. |
| svr_port | bigint(20) | NO | The port number of the OBServer node. |
| sql_port | bigint(20) | NO | The SQL port of the OBServer node. |
| unit_id | bigint(20) | NO | The ID of the unit. |
| partition_cnt | bigint(20) | NO | The number of partitions. This field is no longer in use and is meaningless. |
| zone | varchar(128) | NO | The zone where the replica is located. |
| role | bigint(20) | NO | The role of the replica. Valid values: |
| member_list | varchar(3520) | NO | The list of members in the Paxos group. |
| row_count | bigint(20) | NO | The number of rows. |
| data_size | bigint(20) | NO | The amount of data. |
| data_version | bigint(20) | NO | The data version. |
| partition_checksum | bigint(20) | NO | The checksum of the partition. |
| data_checksum | bigint(20) | NO | The checksum of the data. |
| row_checksum | bigint(20) | NO | The row checksum. |
| column_checksum | varchar(8192) | NO | The column checksum. |
| rebuild | bigint(20) | NO | Indicates whether the partition is in the rebuild state. |
| replica_type | bigint(20) | NO | The replica type. Valid values: |
| required_size | bigint(20) | NO | The size required to migrate the partition. |
| status | varchar(64) | NO | The status of the replica. |
| is_restore | bigint(20) | NO | Indicates whether the replica is being logically or physically restored. |
| quorum | bigint(20) | NO | The number of members that the Paxos group needs to contain. This field is only valid for rows whose role is equal to 1. It is used to calculate the majority. |