SHOW-TABLETS

Name

SHOW TABLETS

Description

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

语法：

1. SHOW TABLETS FROM [database.]table [PARTITIONS(p1,p2)]
2. [WHERE where_condition]
3. [ORDER BY col_name]
4. [LIMIT [offset,] row_count]
  1. Syntax Description:

where_condition 可以为下列条件之一:

1. Version = version
2. state = "NORMAL|ROLLUP|CLONE|DECOMMISSION"
3. BackendId = backend_id
4. IndexName = rollup_name

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

Example

  1. 列出指定table所有的tablets

1. SHOW TABLETS FROM example_db.table_name; 2. 列出指定partitions的所有tablets

1. SHOW TABLETS FROM example_db.table_name PARTITIONS(p1, p2); 3. 列出某个backend上状态为DECOMMISSION的tablets

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

Keywords

1. SHOW, TABLETS

Best Practice