show specific partition hive query code example

Example: show specific partition hive query

SHOW PARTITIONS [db_name.] table_name [PARTITION(partition_spec)];