Skip to main content
Skip to main content

SHOW-TABLETS-BELONG

SHOW-TABLETS-BELONG

Name

SHOW TABLETS BELONG

Description

Used to show tablets and information of their belonging table

grammar:

SHOW TABLETS BELONG tablet-ids;

illustrate:

  1. tablet-ids: one or more tablet-ids, with comma separated
  2. Columns of result keep same with result of SHOW-DATA for the same table

Example

  1. show information of four tablet-ids (actually, three tablet-ids. Result will be deduplicated)

    ```sql
    SHOW TABLETS BELONG 27028,78880,78382,27028;
    ```

    ```

    +---------------------+-----------+-----------+--------------+-----------+--------------+----------------+ | DbName | TableName | TableSize | PartitionNum | BucketNum | ReplicaCount | TabletIds | +---------------------+-----------+-----------+--------------+-----------+--------------+----------------+ | default_cluster:db1 | kec | 613.000 B | 379 | 604 | 604 | [78880, 78382] | | default_cluster:db1 | test | 1.874 KB | 1 | 1 | 1 | [27028] | +---------------------+-----------+-----------+--------------+-----------+--------------+----------------+

    ```

Keywords

SHOW, TABLETS, BELONG

Best Practice