title: Hive External Table - Where is data location meta data stored?
body: <p>I am using Hive external tables on Amazon EMR.  Often these tables are partitioned, with each partition pointing to a different bucket in S3.  I am using MySQL for Hive meta data storage.   </p>
  
  <p>I want to be able to see the location/bucket on S3 that each partition is pointing to.  I have looked into the meta data tables in MySQL.  I can see partition information there, but nothing that indicates that actual location of the data.  </p>
  
  <p>Is this data available in MySQL, or can it be obtained by Hive commands?</p>