title: Is it possible to count the number of partitions?
body: <p>I am working on a test in which I must find out the number of partitions of a table and check if it is right. If I use <code>show partitions TableName</code> I get all the partitions by name, but I wish to get the number of partitions, like something along the lines <code>show count(partitions) TableName</code> (which retuns OK btw.. so it's not good) and get 12 (for ex.).
  <br> Is there any way to achieve this??</p>