You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-user@hadoop.apache.org by Kumar Jayapal <kj...@gmail.com> on 2015/04/30 23:14:10 UTC

How to move back to .gz file from hive to hdfs

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

Re: How to move back to .gz file from hive to hdfs

Posted by Alexander Pivovarov <ap...@gmail.com>.
try
desc formatted <table_name>;
it shows you table location on hdfs

On Thu, Apr 30, 2015 at 2:43 PM, Kumar Jayapal <kj...@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" <kj...@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
>>>
>>
>

Re: How to move back to .gz file from hive to hdfs

Posted by Alexander Pivovarov <ap...@gmail.com>.
try
desc formatted <table_name>;
it shows you table location on hdfs

On Thu, Apr 30, 2015 at 2:43 PM, Kumar Jayapal <kj...@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" <kj...@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
>>>
>>
>

Re: How to move back to .gz file from hive to hdfs

Posted by Alexander Pivovarov <ap...@gmail.com>.
try
desc formatted <table_name>;
it shows you table location on hdfs

On Thu, Apr 30, 2015 at 2:43 PM, Kumar Jayapal <kj...@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" <kj...@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
>>>
>>
>

Re: How to move back to .gz file from hive to hdfs

Posted by Alexander Pivovarov <ap...@gmail.com>.
try
desc formatted <table_name>;
it shows you table location on hdfs

On Thu, Apr 30, 2015 at 2:43 PM, Kumar Jayapal <kj...@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" <kj...@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
>>>
>>
>

Re: How to move back to .gz file from hive to hdfs

Posted by Kumar Jayapal <kj...@gmail.com>.
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 <ap...@gmail.com>
wrote:

> Try to find the file in hdfs trash
> On Apr 30, 2015 2:14 PM, "Kumar Jayapal" <kj...@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
>>
>

Re: How to move back to .gz file from hive to hdfs

Posted by Kumar Jayapal <kj...@gmail.com>.
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 <ap...@gmail.com>
wrote:

> Try to find the file in hdfs trash
> On Apr 30, 2015 2:14 PM, "Kumar Jayapal" <kj...@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
>>
>

Re: How to move back to .gz file from hive to hdfs

Posted by Kumar Jayapal <kj...@gmail.com>.
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 <ap...@gmail.com>
wrote:

> Try to find the file in hdfs trash
> On Apr 30, 2015 2:14 PM, "Kumar Jayapal" <kj...@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
>>
>

Re: How to move back to .gz file from hive to hdfs

Posted by Kumar Jayapal <kj...@gmail.com>.
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 <ap...@gmail.com>
wrote:

> Try to find the file in hdfs trash
> On Apr 30, 2015 2:14 PM, "Kumar Jayapal" <kj...@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
>>
>

Re: How to move back to .gz file from hive to hdfs

Posted by Alexander Pivovarov <ap...@gmail.com>.
Try to find the file in hdfs trash
On Apr 30, 2015 2:14 PM, "Kumar Jayapal" <kj...@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
>

Re: How to move back to .gz file from hive to hdfs

Posted by Alexander Pivovarov <ap...@gmail.com>.
Try to find the file in hdfs trash
On Apr 30, 2015 2:14 PM, "Kumar Jayapal" <kj...@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
>

Re: How to move back to .gz file from hive to hdfs

Posted by Alexander Pivovarov <ap...@gmail.com>.
Try to find the file in hdfs trash
On Apr 30, 2015 2:14 PM, "Kumar Jayapal" <kj...@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
>

Re: How to move back to .gz file from hive to hdfs

Posted by Alexander Pivovarov <ap...@gmail.com>.
Try to find the file in hdfs trash
On Apr 30, 2015 2:14 PM, "Kumar Jayapal" <kj...@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
>