hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hadoop Raj <hadoop...@yahoo.com>
Subject Re: How can I just find out the physical location of a partitioned table in Hive
Date Thu, 06 Feb 2014 20:19:32 GMT
Thank you. That worked perfect for me.

Sent from my iPhone

> On Feb 6, 2014, at 1:45 PM, Edward Capriolo <edlinuxguru@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 <hadoopraj@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 <bruderman@radiumone.com> wrote:
>>> 
>>> desc extended "table name"
>>> 
>>> Thanks,
>>> Brad
>>> 
>>> 
>>>> On Thu, Feb 6, 2014 at 10:23 AM, Raj Hadoop <hadoopraj@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
> 

Mime
View raw message