How to show all partitions of a table in Hive

Question

Hi Team,

I have created one table in the Hive database. I want to list down all the partitions of that table. Can anyone tell me how to do that?

Answer 1

Hi@akhtar,

You can list down all the partitions of a table in two ways. One is using the hive command, and another one is with the hive prompt. You can see the below example.

$hive -e show partitions table_name;

$ hive> show partitions table_name;