title: Hive: how to show all partitions of a table?
body: <p>I have a table with 1000+ partitions. </p>
  
  <p>"<code>Show partitions</code>" command only lists a small number of partitions.</p>
  
  <p>How can i show all partitions?</p>
  
  <p>Update:</p>
  
  <ol>
  <li><p>I found "<code>show partitions</code>" command only lists exactly 500 partitions.</p></li>
  <li><p>"<code>select ... where ...</code>" only processes the 500 partitions!</p></li>
  </ol>