Hive External Table - Where is data location meta data stored?

amazon-s3, emr, hadoop, hive, mysql

Solution

The following hive command can be used to get the location

hive> `show create table <TableName>;`

Please search for the line LOCATION in the output of the above hive command.

Problem

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. 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. Is this data available in MySQL, or can it be obtained by Hive commands?

Original source