SHOW PARTITION ID
Description
This statement is used to find the corresponding database name, table name, and partition name based on the partition ID.
Syntax
SHOW PARTITION <partition_id>
Required Parameters
1. <partition_id>
partition id
Access Control Requirements
The user who executes this SQL must have at least the following permissions:
| Privilege | Object | Notes |
|---|---|---|
| ADMIN_PRIV |
Examples
-
To find the corresponding database name, table name, and partition name based on the partition ID.
SHOW PARTITION 10002;
