Skip to main content
Get StartedConsole GuideWork With DataRelease NotesReference
Resources
VeloDB Cloud 26.x·Apache Doris 4.x (up to 4.0 supported)·"Since X.Y" tags refer to Apache 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;