ADMIN CANCEL REPAIR
Description
This statement is used to cancel repairing specified tables or partitions with high priority.
tip
This operation requires the SYSTEM-level OPERATE privilege. You can follow the instructions in GRANT to grant this privilege.
Syntax
ADMIN CANCEL REPAIR TABLE table_name[ PARTITION (p1,...)]
Note
This statement only indicates that the system will no longer repair sharding replicas of specified tables or partitions with high priority. It still repairs these copies by default scheduling.
Examples
-
Cancel high priority repair
ADMIN CANCEL REPAIR TABLE tbl PARTITION(p1);