Java – Hive describes a partition to display the partition URL

I know there is

DESCRIBE FORMATTED table_name;

Displays a table format.

Is there a way to get more information about zoning other than ?

SHOW PARTITIONS table_name;

I saw that the Hive language manual has this

DESCRIBE [EXTENDED| FORMATTED] [db_name.] table_name PARTITION partition_spec

I want to see all partitions and URLs in HDFS or S3 where data is stored.

Show Partitions:

Displays the partition table name

Show the physical storage location of the partition:

Describes the formatted dbname.tablename partition (name=value).

I don’t know of any built-in way to create the output (partitions, paths), but you can build it with both commands and some grep/awk or whatever.