SHOW-TABLETS

Name

SHOW TABLETS

Description

该语句用于列出指定table的所有tablets（仅管理员使用）

语法：

SHOW TABLETS FROM [database.]table [PARTITIONS(p1,p2)]
[WHERE where_condition]
[ORDER BY col_name]
[LIMIT [offset,] row_count]

1. Syntax Description:

where_condition 可以为下列条件之一:

    Version = version
    state = "NORMAL|ROLLUP|CLONE|DECOMMISSION"
    BackendId = backend_id

或者通过AND组合的复合条件.

Example

1. 列出指定table所有的tablets

   SHOW TABLETS FROM example_db.table_name;

2. 列出指定partitions的所有tablets

   SHOW TABLETS FROM example_db.table_name PARTITIONS(p1, p2);

3. 列出某个backend上状态为DECOMMISSION的tablets

   SHOW TABLETS FROM example_db.table_name WHERE state="DECOMMISSION" AND BackendId=11003;

Keywords

SHOW, TABLETS

Best Practice