title: Athena partition locations
body: <p>I can view all the partitions on my table using </p>
  
  <pre><code>show partitions my_table
  </code></pre>
  
  <p>and I can see the location of a partition by using </p>
  
  <pre><code>describe formatted my_table partition (partition_col='value')
  </code></pre>
  
  <p>but I have a lot of partitions, and don't want to have to parse the output of <code>describe formatted</code> if it can be avoided.</p>
  
  <p>Is there a way to get all partitions and their locations, in a single query?</p>