SHOW-TABLETS
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]
- Syntax Description:
where_condition 可以为下列条件之一:
Version = version
state = "NORMAL|ROLLUP|CLONE|DECOMMISSION"
BackendId = backend_id
IndexName = rollup_name
或者通过AND
组合的复合条件.
Example
列出指定table所有的tablets
SHOW TABLETS FROM example_db.table_name;
列出指定partitions的所有tablets
SHOW TABLETS FROM example_db.table_name PARTITIONS(p1, p2);
列出某个backend上状态为DECOMMISSION的tablets
SHOW TABLETS FROM example_db.table_name WHERE state="DECOMMISSION" AND BackendId=11003;
Keywords
SHOW, TABLETS