Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hadoop.apache.org
Received-SPF: pass (athena.apache.org: message received from 54.191.145.13
 which is an MX secondary for user@hadoop.apache.org)
MIME-Version: 1.0
In-Reply-To: 
 <CAPCS4qpDYFiDP0yjSGoikkrD_N0CvG9kNzxajbWq93Mrrz-9hA@mail.gmail.com>
References: 
 <CAPCS4qrjF6BVBD-rj2PevGCXnWJwE1jj7izXBbRS7Lh3BgoERQ@mail.gmail.com>
 <CAKKt98R0fRo8hg+8rVZgn5e+LE_eG0BGxiFPrQB-1=50dmB=7g@mail.gmail.com>
 <CAPCS4qpDYFiDP0yjSGoikkrD_N0CvG9kNzxajbWq93Mrrz-9hA@mail.gmail.com>
From: Alexander Pivovarov <apivovarov@gmail.com>
Date: Thu, 30 Apr 2015 14:59:49 -0700
Message-ID: 
 <CAKKt98RfbRFV=5vaWwDEOoXgmE1yOSZUKBfe43m2KLoTwqoMVA@mail.gmail.com>
Subject: Re: How to move back to .gz file from hive to hdfs
To: user@hadoop.apache.org
Content-Type: multipart/alternative; boundary=001a11342c2c1c448c0514f8385f

--001a11342c2c1c448c0514f8385f
Content-Type: text/plain; charset=UTF-8

try
desc formatted <table_name>;
it shows you table location on hdfs

On Thu, Apr 30, 2015 at 2:43 PM, Kumar Jayapal <kjayapal17@gmail.com> wrote:

> I did not find it in .Trash file is moved to hive table I want to move it
> back to hdfs.
>
> On Thu, Apr 30, 2015 at 2:20 PM, Alexander Pivovarov <apivovarov@gmail.com
> > wrote:
>
>> Try to find the file in hdfs trash
>> On Apr 30, 2015 2:14 PM, "Kumar Jayapal" <kjayapal17@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> I loaded one file to hive table it is in .gz extension. file is
>>> moved/deleted from hdfs.
>>>
>>> when I execute select command I get an error.
>>>
>>> Error: Error while processing statement: FAILED: Execution Error, return
>>> code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
>>> (state=08S01,code=2)
>>>
>>> how can I move back the file to HDFS. how can I do it.
>>>
>>> Thanks
>>> Jay
>>>
>>
>

--001a11342c2c1c448c0514f8385f
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div>try<br></div>desc formatted &lt;table_name&gt;;<=
br></div>it shows you table location on hdfs<br></div><div class=3D"gmail_e=
xtra"><br><div class=3D"gmail_quote">On Thu, Apr 30, 2015 at 2:43 PM, Kumar=
 Jayapal <span dir=3D"ltr">&lt;<a href=3D"mailto:kjayapal17@gmail.com" targ=
et=3D"_blank">kjayapal17@gmail.com</a>&gt;</span> wrote:<br><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;pa=
dding-left:1ex"><div dir=3D"ltr">I did not find it in .Trash file is moved =
to hive table I want to move it back to hdfs.</div><div class=3D"HOEnZb"><d=
iv class=3D"h5"><div class=3D"gmail_extra"><br><div class=3D"gmail_quote">O=
n Thu, Apr 30, 2015 at 2:20 PM, Alexander Pivovarov <span dir=3D"ltr">&lt;<=
a href=3D"mailto:apivovarov@gmail.com" target=3D"_blank">apivovarov@gmail.c=
om</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"marg=
in:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p dir=3D"ltr">T=
ry to find the file in hdfs trash</p><div><div>
<div class=3D"gmail_quote">On Apr 30, 2015 2:14 PM, &quot;Kumar Jayapal&quo=
t; &lt;<a href=3D"mailto:kjayapal17@gmail.com" target=3D"_blank">kjayapal17=
@gmail.com</a>&gt; wrote:<br type=3D"attribution"><blockquote class=3D"gmai=
l_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left=
:1ex"><div dir=3D"ltr"><div>Hi,</div><div><br></div><div>I loaded one file =
to hive table=C2=A0it is in .gz extension. file is moved/deleted from hdfs.=
</div><div><br></div><div>when I execute select command I get an error.</di=
v><div><br></div><div>Error: Error while processing statement: FAILED: Exec=
ution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTas=
k (state=3D08S01,code=3D2)</div><div><br></div><div>how can I move back the=
 file to HDFS. how can I do it.</div><div><br></div><div>Thanks</div><div>J=
ay</div></div>
</blockquote></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>

--001a11342c2c1c448c0514f8385f--