Hive: how to show all partitions of a table?

hadoop, hive

Solution

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

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

Problem

I have a table with 1000+ partitions. "`Show partitions`" command only lists a small number of partitions. How can i show all partitions? Update: I found "`show partitions`" command only lists exactly 500 partitions. "`select ... where ...`" only processes the 500 partitions!

Original source