ADMIN CHECK TABLET
Description
This statement is used to perform the specified check operation on a set of tablets.
Syntax
ADMIN CHECK TABLET ( <tablet_id> [,...] ) PROPERTIES("type" = "<type_value>")
Required Parameters
1. <tablet_id>
The ID of the tablet on which the specified check operation will be performed.
Optional Parameters
1. <type_value>
Currently, only consistency is supported.
-
consistency:
Checks the replica data consistency of the tablet. This command is asynchronous, meaning that after sending it, Doris will start executing the consistency check job for the corresponding tablet.
Return Value
The final result of the statement will be reflected in the InconsistentNum column of the result from SHOW PROC "/cluster_health/tablet_health";.
| Column | DataType | Note |
|---|---|---|
| InconsistentNum | Int | Number of tablets with inconsistency |
Access Control Requirements
The user executing this SQL command must have at least the following privileges:
| Privilege | Object | Notes |
|---|---|---|
| Admin_priv | Database | Required to execute administrative operations on the database, including managing tables, partitions, and system-level commands. |
Examples
-
Perform a replica data consistency check on a specified set of tablets
admin check tablet (10000, 10001) PROPERTIES("type" = "consistency");
