SHOW PARTITION
Description
SHOW PARTITION is used to display detailed information about a specified partition. This includes the name and ID of the associated database, the name and ID of the associated table, and the partition name.
Syntax
SHOW PARTITION <partition_id>
Required Parameters
<partition_id>
The ID of the partition. The partition ID can be obtained through methods such as SHOW PARTITIONS. For more information, please refer to the "SHOW PARTITIONS" section.
Access Control Requirements
The user executing this SQL command must have at least ADMIN_PRIV
permissions.
Examples
Query partition information for partition ID 13004:
SHOW PARTITION 13004;
Results:
+--------+-----------+---------------+-------+---------+
| DbName | TableName | PartitionName | DbId | TableId |
+--------+-----------+---------------+-------+---------+
| ods | sales | sales | 13003 | 13005 |
+--------+-----------+---------------+-------+---------+