Hive: how to show all partitions of a table?

I have a table with 1000+ partitions.

Show partitions” command only lists a small number of partitions.

How can i show all partitions?

Update:

  1. I found “show partitions” command only lists exactly 500 partitions.
  2. select ... where ...” only processes the 500 partitions!

Leave a Comment