Is there an easy/elegant way to query hive for a table's (and a partition's) location in HDFS?
I'm aware that you can get the location using "describe extended table_name" but it like to be able to query on just the location key. If not, is there a way to do so using the mysql metastore db? Ideally, I'd come out with something like: hdfs://namenode:/user/hive/warehouse/database.db/table/partition_1/datafile Thanks!