SHOW TABLET

description

This statement is used to display tablet related information (for administrators only)

Syntax:

SHOW TABLET
[FROM [db_name.]table_name | tablet_id] [partiton(partition_name_1, partition_name_1)]
[where [version=1] [and backendid=10000] [and state="NORMAL|ROLLUP|CLONE|DECOMMISSION"]]
[order by order_column]
[limit [offset,]size]

Now the show tablet command supports filtering according to the following fields: partition, index, name, version, backendid, state. It also supports sorting according to any field, and provides a limit to limit the number of returned items.

example

  1. Displays all the table information of the specified db table

    SHOW TABLET FROM example_db.table_name;
    // Get the tablet information of partition p1 and p2
    SHOW TABLET FROM example_db.table_name partition(p1, p2);
    
    // Get 10 results
    SHOW TABLET FROM example_db.table_name limit 10;
    
    // Get 10 results from offset 5
    SHOW TABLET FROM example_db.table_name limit 5,10;
    
    // Filter by backendid / version / state field
    SHOW TABLET FROM example_db.table_name where backendid=10000 and version=1 and state="NORMAL";
    
    // Sort by version field
    SHOW TABLET FROM example_db.table_name where backendid=10000 order by version;
    
    // Get the index name as T1_ Rollup tablet related information
    SHOW TABLET FROM example_db.table_name where indexname="t1_rollup";
  2. Displays the parent level id information of a tablet with a specified tablet id of 10000

    SHOW TABLET 10000;

keyword

SHOW,TABLET,LIMIT