title: How to know location about partition in hive?
body: <p>If I write a hive sql like</p>
  
  <pre><code>ALTER TABLE tbl_name ADD PARTITION (dt=20131023) LOCATION 'hdfs://path/to/tbl_name/dt=20131023;
  </code></pre>
  
  <p>How can I query this location about partition later? Because I found there is some data in  location but I can't query them, hive sql like</p>
  
  <pre><code>SELECT data FROM tbl_name where dt=20131023;
  </code></pre>