Skip to main content
VeloDB Cloud 26.x·Apache Doris 4.x (≤ 4.0 supported)·"Since X.Y" tags refer to Doris versionsversion mapping →

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:

PrivilegeObjectNotes
ADMIN_PRIV

Examples​

  1. To find the corresponding database name, table name, and partition name based on the partition ID.

    SHOW PARTITION 10002;