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> > > >> 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 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 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 >