title: Getting Partition_Info in athena
body: <pre><code>SELECT *
  FROM   information_schema.__internal_partitions__
  WHERE  table_schema = 's1'
  AND table_name = 't1'
  ORDER  BY partition_numberenter code here
  </code></pre>
  
  <p>Can we get partition details for all the tables at the same time using the above query ? Like where table_schema IN (s1,s2) AND table_name IN (t1,t2)</p>