Hive: how to show all partitions of a table? Hive: how to show all partitions of a table? hadoop hadoop

Hive: how to show all partitions of a table?


CLI has some limit when ouput is displayed. I suggest to export output into local file:

$hive -e 'show partitions table;' > partitions


hive> show partitions table_name;


You can see Hive MetaStore tables,Partitions information in table of "PARTITIONS".You could use "TBLS" join "Partition" to query special table partitions.