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