Return-Path: 
 <user-return-15497-apmail-hive-user-archive=hive.apache.org@hive.apache.org>
X-Original-To: apmail-hive-user-archive@www.apache.org
Delivered-To: apmail-hive-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 1157110C32
	for <apmail-hive-user-archive@www.apache.org>;
 Thu,  6 Feb 2014 18:25:49 +0000 (UTC)
Received: (qmail 67571 invoked by uid 500); 6 Feb 2014 18:25:46 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 67433 invoked by uid 500); 6 Feb 2014 18:25:46 -0000
Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hive.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hive.apache.org>
List-Post: <mailto:user@hive.apache.org>
List-Id: <user.hive.apache.org>
Reply-To: user@hive.apache.org
Delivered-To: mailing list user@hive.apache.org
Received: (qmail 67424 invoked by uid 99); 6 Feb 2014 18:25:46 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Feb 2014 18:25:46 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of bruderman@radiumone.com
 designates 209.85.213.174 as permitted sender)
Received: from [209.85.213.174] (HELO mail-ig0-f174.google.com)
 (209.85.213.174)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Feb 2014 18:25:40 +0000
Received: by mail-ig0-f174.google.com with SMTP id hl1so212960igb.1
        for <user@hive.apache.org>; Thu, 06 Feb 2014 10:25:19 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=radiumone.com; s=google;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type;
        bh=9XfDNynte+iCtMdOvFKuJ7q+Bj0y6IXQaBjrrqxPxEY=;
        b=eX+R0N6rhv5QANMaJm+qij6tYfMqFiI7QUt3DZ4t4sHsKGLy7xbBtspPk+dNvjsorO
         ai7Cq62D4rFMVI5Wg83F61ByrOBwf3/JcYzsOb84z0T0uxgVY/iLb/FLYp3QVRXkvmEL
         OCFOjEdMMRlQ+7383U4OUhNoiRF2+FJDkKRYM=
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20130820;
        h=x-gm-message-state:mime-version:in-reply-to:references:from:date
         :message-id:subject:to:content-type;
        bh=9XfDNynte+iCtMdOvFKuJ7q+Bj0y6IXQaBjrrqxPxEY=;
        b=EYUnbpVs25nH/unIbfYpkVox8heWElchXxLZvYUDWDVNWYj7UGt41oa+exMHq53ShS
         2Z5lV6Yw4DEBg2sD93FjYekjoJdBkX+MDapaskmxFFk1X/ggwL4DGs9lJbYh3+h99Q6B
         nlFuGy+0oQDLPordUo3tuFm6Bqv4AdSvzHYLfDRCi7nmAZJz8onIuQBZdgO3+48jYYjr
         w6ikz94RQ0vb4/Qdn2pNywnARf4LHK5aZhTFVGDcFYmW99n9++tdCD5UILnC+E7BnD5s
         bLjTrD9U+pQVlrrD57Loh1pjgfEbFBwbmPg0QG0w5iFYlwIGWxFLHQomlJCycASjJoW5
         C68g==
X-Gm-Message-State: 
 ALoCoQk0G7x3hPOnB5eDf0CAoFWSoGeldI37nuZA3yzJ9FOiHMyMDdPAgLP6CbD3BY7NjHD/ZEXD
X-Received: by 10.50.128.137 with SMTP id no9mr573380igb.36.1391711119160;
 Thu, 06 Feb 2014 10:25:19 -0800 (PST)
MIME-Version: 1.0
Received: by 10.50.36.161 with HTTP; Thu, 6 Feb 2014 10:24:59 -0800 (PST)
In-Reply-To: <1391711031.72371.YahooMailNeo@web120705.mail.ne1.yahoo.com>
References: <1391711031.72371.YahooMailNeo@web120705.mail.ne1.yahoo.com>
From: Brad Ruderman <bruderman@radiumone.com>
Date: Thu, 6 Feb 2014 10:24:59 -0800
Message-ID: 
 <CANFGO9obK4PU8u2Wkf=cVPphCacbZ98sUzrz5TgD_qXJsce55g@mail.gmail.com>
Subject: Re: How can I just find out the physical location of a partitioned
 table in Hive
To: user@hive.apache.org, Raj Hadoop <hadoopraj@yahoo.com>
Content-Type: multipart/alternative; boundary=047d7b10cf0de38a2d04f1c0fef9
X-Virus-Checked: Checked by ClamAV on apache.org

--047d7b10cf0de38a2d04f1c0fef9
Content-Type: text/plain; charset=ISO-8859-1

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
>

--047d7b10cf0de38a2d04f1c0fef9
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">desc extended &quot;table name&quot;<div><br></div><div>Th=
anks,</div><div>Brad</div></div><div class=3D"gmail_extra"><br><br><div cla=
ss=3D"gmail_quote">On Thu, Feb 6, 2014 at 10:23 AM, Raj Hadoop <span dir=3D=
"ltr">&lt;<a href=3D"mailto:hadoopraj@yahoo.com" target=3D"_blank">hadoopra=
j@yahoo.com</a>&gt;</span> wrote:<br>

<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div><div style=3D"font-size:12pt;font-famil=
y:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif"><d=
iv>

Hi,</div><div><br></div><div style=3D"font-style:normal;font-size:16px;back=
ground-color:transparent;font-family:HelveticaNeue,&#39;Helvetica Neue&#39;=
,Helvetica,Arial,&#39;Lucida Grande&#39;,sans-serif">How can I just find ou=
t the physical location of a partitioned table in Hive.<br>

</div><div style=3D"font-style:normal;font-size:16px;background-color:trans=
parent;font-family:HelveticaNeue,&#39;Helvetica Neue&#39;,Helvetica,Arial,&=
#39;Lucida Grande&#39;,sans-serif"><br></div><div style=3D"font-style:norma=
l;font-size:16px;background-color:transparent;font-family:HelveticaNeue,&#3=
9;Helvetica Neue&#39;,Helvetica,Arial,&#39;Lucida Grande&#39;,sans-serif">

<span style=3D"white-space:pre-wrap">	</span>Show partitions &lt;tab
 name&gt;</div><div style=3D"font-style:normal;font-size:16px;background-co=
lor:transparent;font-family:HelveticaNeue,&#39;Helvetica Neue&#39;,Helvetic=
a,Arial,&#39;Lucida Grande&#39;,sans-serif"><br></div><div style=3D"font-st=
yle:normal;font-size:16px;background-color:transparent;font-family:Helvetic=
aNeue,&#39;Helvetica Neue&#39;,Helvetica,Arial,&#39;Lucida Grande&#39;,sans=
-serif">

<span style=3D"white-space:pre-wrap">	</span>gives me just the partition co=
lumn info.</div><div style=3D"font-style:normal;font-size:16px;background-c=
olor:transparent;font-family:HelveticaNeue,&#39;Helvetica Neue&#39;,Helveti=
ca,Arial,&#39;Lucida Grande&#39;,sans-serif">

<br></div><div style=3D"font-style:normal;font-size:16px;background-color:t=
ransparent;font-family:HelveticaNeue,&#39;Helvetica Neue&#39;,Helvetica,Ari=
al,&#39;Lucida Grande&#39;,sans-serif">I want the location of the hdfs dire=
ctory /
 files where the table is created.</div><div style=3D"font-style:normal;fon=
t-size:16px;background-color:transparent;font-family:HelveticaNeue,&#39;Hel=
vetica Neue&#39;,Helvetica,Arial,&#39;Lucida Grande&#39;,sans-serif"><br>

</div><div style=3D"font-style:normal;font-size:16px;background-color:trans=
parent;font-family:HelveticaNeue,&#39;Helvetica Neue&#39;,Helvetica,Arial,&=
#39;Lucida Grande&#39;,sans-serif">Please advise.</div><div style=3D"font-s=
tyle:normal;font-size:16px;background-color:transparent;font-family:Helveti=
caNeue,&#39;Helvetica Neue&#39;,Helvetica,Arial,&#39;Lucida Grande&#39;,san=
s-serif">

<br></div><div style=3D"font-style:normal;font-size:16px;background-color:t=
ransparent;font-family:HelveticaNeue,&#39;Helvetica Neue&#39;,Helvetica,Ari=
al,&#39;Lucida Grande&#39;,sans-serif">Thanks,</div><div style=3D"font-styl=
e:normal;font-size:16px;background-color:transparent;font-family:HelveticaN=
eue,&#39;Helvetica Neue&#39;,Helvetica,Arial,&#39;Lucida Grande&#39;,sans-s=
erif">

Raj</div></div></div></blockquote></div><br></div>

--047d7b10cf0de38a2d04f1c0fef9--