title: hive, get the data location using an one-liner
body: <p>I wonder if there is a way to get the data location from hive using a one-liner.  Something like </p>
  
  <pre><code>select d.location from ( describe formatted table_name partition ( .. ) ) as d;
  </code></pre>
  
  <p>My current solution is to get the full output and then parse it. </p>