SHOW TABLET
Description
This statement is used to show details of a specific tablet (only for administrators).
Syntax
SHOW TABLET <tablet_id>;
Required Parameters
1. <tablet_id>
The ID of the specific tablet to display information for.
Return Value
When using SHOW TABLET <tablet_id>
, the following columns are returned:
Column | DataType | Note |
---|---|---|
DbName | String | The name of the database that contains the tablet. |
TableName | String | The name of the table that contains the tablet. |
PartitionName | String | The name of the partition that contains the tablet. |
IndexName | String | The name of the index that contains the tablet. |
DbId | Int | The ID of the database. |
TableId | Int | The ID of the table. |
PartitionId | Int | The ID of the partition. |
IndexId | Int | The ID of the index. |
IsSync | Boolean | Whether the tablet is in sync with its replicas. |
Order | Int | The order of the tablet. |
QueryHits | Int | The number of query hits on this tablet. |
DetailCmd | String | The command to get more detailed information about the tablet. |
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
Show details of a specific tablet:
SHOW TABLET 10145;
+--------+-----------+---------------+-----------+-------+---------+-------------+---------+--------+-------+-----------+------------------------------------------------------------+
| DbName | TableName | PartitionName | IndexName | DbId | TableId | PartitionId | IndexId | IsSync | Order | QueryHits | DetailCmd |
+--------+-----------+---------------+-----------+-------+---------+-------------+---------+--------+-------+-----------+------------------------------------------------------------+
| test | sell_user | sell_user | sell_user | 10103 | 10143 | 10142 | 10144 | true | 0 | 0 | SHOW PROC '/dbs/10103/10143/partitions/10142/10144/10145'; |
+--------+-----------+---------------+-----------+-------+---------+-------------+---------+--------+-------+-----------+------------------------------------------------------------+