SHOW-REPLICA-STATUS
SHOW-REPLICA-STATUS
Name
SHOW REPLICA STATUS
Description
This statement is used to display replica status information for a table or partition.
grammar:
SHOW REPLICA STATUS FROM [db_name.]tbl_name [PARTITION (p1, ...)]
[where_clause];
illustrate
where_clause: WHERE STATUS [!]= "replica_status"
replica_status: OK: replica is healthy DEAD: The Backend where the replica is located is unavailable VERSION_ERROR: replica data version is missing SCHEMA_ERROR: The schema hash of the replica is incorrect MISSING: replica does not exist
Example
View the status of all replicas of the table
SHOW REPLICA STATUS FROM db1.tbl1;
View a copy of a table with a partition status of VERSION_ERROR
SHOW REPLICA STATUS FROM tbl1 PARTITION (p1, p2)
WHERE STATUS = "VERSION_ERROR";View all unhealthy replicas of the table
SHOW REPLICA STATUS FROM tbl1
WHERE STATUS != "OK";
Keywords
SHOW, REPLICA, STATUS