ADMIN SHOW REPLICA STATUS
Description
This statement is used to display copy status information for a table or partition
Grammar:
ADMIN SHOW REPLICA STATUS FROM [dbu name.]tbl name [PARTITION (p1,…)] [where_clause];
where_clause: WHERE STATUS [!]= “replica_status”
Reply status: OK: Replica 22788;’20581;’ 29366;’24577; DEAD: The Backend of replica is not available VERSION_ERROR: The replica data version is missing SCHEMA ERROR: replica schema hash MISSING: replica does not exist
example
- View the status of all copies of the table
ADMIN SHOW REPLICA STATUS FROM db1.tbl1;
- View a copy of a partition state of the table as VERSION_ERROR
ADMIN SHOW REPLICA STATUS FROM tbl1 PARTITION (p1, p2)
- Check all unhealthy copies of the table
ADMIN SHOW REPLICA STATUS FROM tbl1 WHERE STATUS != “OK”;
keyword
ADMIN,SHOW,REPLICA,STATUS