SHOW-TABLETS-BELONG

Name

SHOW TABLETS BELONG

Description

Used to show tablets and information of their belonging table

grammar:

  1. 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)

    1. ```sql
    2. SHOW TABLETS BELONG 27028,78880,78382,27028;
    3. ```
    4. ```

    +——————————-+—————-+—————-+———————+—————-+———————+————————+ | 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] | +——————————-+—————-+—————-+———————+—————-+———————+————————+

    1. ```

Keywords

  1. SHOW, TABLETS, BELONG

Best Practice