How can I just find out the physical location of a partitioned table in Hive

2014-02-06 Thread Raj Hadoop
Hi, How can I just find out the physical location of a partitioned table in Hive. Show partitions tab name gives me just the partition column info. I want the location of the hdfs directory / files where the table is created. Please advise. Thanks, Raj

Re: How can I just find out the physical location of a partitioned table in Hive

2014-02-06 Thread Brad Ruderman
desc extended table name Thanks, Brad On Thu, Feb 6, 2014 at 10:23 AM, Raj Hadoop hadoop...@yahoo.com wrote: Hi, How can I just find out the physical location of a partitioned table in Hive. Show partitions tab name gives me just the partition column info. I want the location of

Re: How can I just find out the physical location of a partitioned table in Hive

2014-02-06 Thread Edward Capriolo
Describe formatted gives you information on the location. I believe you can do describe formatted table describe formated table partition partition On Thu, Feb 6, 2014 at 1:43 PM, Hadoop Raj hadoop...@yahoo.com wrote: That doesn't show the hdfs location . Isn't it ? I tried . Sent from my

Re: How can I just find out the physical location of a partitioned table in Hive

2014-02-06 Thread Hadoop Raj
That doesn't show the hdfs location . Isn't it ? I tried . Sent from my iPhone On Feb 6, 2014, at 1:24 PM, Brad Ruderman bruder...@radiumone.com wrote: desc extended table name Thanks, Brad On Thu, Feb 6, 2014 at 10:23 AM, Raj Hadoop hadoop...@yahoo.com wrote: Hi, How can I just

Re: How can I just find out the physical location of a partitioned table in Hive

2014-02-06 Thread Hadoop Raj
Thank you. That worked perfect for me. Sent from my iPhone On Feb 6, 2014, at 1:45 PM, Edward Capriolo edlinuxg...@gmail.com wrote: Describe formatted gives you information on the location. I believe you can do describe formatted table describe formated table partition partition