Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> How can I just find out the physical location of a partitioned table in Hive


Copy link to this message
-
Re: How can I just find out the physical location of a partitioned table in Hive
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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote:
>
> desc extended "table name"
>
> Thanks,
> Brad
>
>
> On Thu, Feb 6, 2014 at 10:23 AM, Raj Hadoop <[EMAIL PROTECTED]> 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
>>
>
>