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:
- tablet-ids: one or more tablet-ids, with comma separated
- Columns of result keep same with result of
SHOW-DATA
for the same table
Example
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