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

Switch to Threaded View
Hive, mail # user - FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask


Copy link to this message
-
Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
Shreepadma Venugopalan 2012-10-30, 00:36
Hi Robin,

Can you attach the execution logs? The logs contain the exception stack.

Thanks,
Shreepadma

On Mon, Oct 29, 2012 at 10:19 AM, Chen Song <[EMAIL PROTECTED]> wrote:

> Is there anything interesting on hive.log?
>
> If you are running Hive shell with root user, by default, the hive.log
> should be in /tmp/hive.log.
>
> BTW, are you using MySQL as your metastore?
>
> On Mon, Oct 29, 2012 at 12:22 PM, Robin Verlangen <[EMAIL PROTECTED]> wrote:
>
>> I have to add, while trying to do other operations on hive by hand, it
>> also fails.
>>
>> For example:
>> *hive> drop table my_other_table;*
>> *FAILED: Error in metadata:
>> java.lang.reflect.UndeclaredThrowableException*
>> *FAILED: Execution Error, return code 1 from
>> org.apache.hadoop.hive.ql.exec.DDLTask*
>>
>>
>> Best regards,
>>
>> Robin Verlangen
>> *Software engineer*
>> *
>> *
>> W http://www.robinverlangen.nl
>> E [EMAIL PROTECTED]
>>
>> <http://goo.gl/Lt7BC>
>>
>> Disclaimer: The information contained in this message and attachments is
>> intended solely for the attention and use of the named addressee and may be
>> confidential. If you are not the intended recipient, you are reminded that
>> the information remains the property of the sender. You must not use,
>> disclose, distribute, copy, print or rely on this e-mail. If you have
>> received this message in error, please contact the sender immediately and
>> irrevocably delete this message and any copies.
>>
>>
>>
>> 2012/10/29 Robin Verlangen <[EMAIL PROTECTED]>
>>
>>> Hi Chen,
>>>
>>> The user that ran this job is root and all hdfs folders are also owned
>>> by root.
>>>
>>> Best regards,
>>>
>>> Robin Verlangen
>>> *Software engineer*
>>> *
>>> *
>>> W http://www.robinverlangen.nl
>>> E [EMAIL PROTECTED]
>>>
>>> <http://goo.gl/Lt7BC>
>>>
>>> Disclaimer: The information contained in this message and attachments is
>>> intended solely for the attention and use of the named addressee and may be
>>> confidential. If you are not the intended recipient, you are reminded that
>>> the information remains the property of the sender. You must not use,
>>> disclose, distribute, copy, print or rely on this e-mail. If you have
>>> received this message in error, please contact the sender immediately and
>>> irrevocably delete this message and any copies.
>>>
>>>
>>>
>>> 2012/10/29 Chen Song <[EMAIL PROTECTED]>
>>>
>>>> Looks to me the permission issue.
>>>>
>>>> Can you check if the user (which ran the hive query) has write
>>>> permission on */user/hive/warehouse/mydatabase.db/mytable?*
>>>>
>>>> On Mon, Oct 29, 2012 at 8:38 AM, Robin Verlangen <[EMAIL PROTECTED]> wrote:
>>>>
>>>>> Hi there,
>>>>>
>>>>> Since today our Hive jobs suddenly fail (nothing changed actually).
>>>>> The end looks like this:
>>>>>
>>>>> *MapReduce Total cumulative CPU time: 38 minutes 31 seconds 260 msec*
>>>>> *Ended Job = job_201210291304_0015*
>>>>> *Loading data to table mydatabase.mytable*
>>>>> *rmr: DEPRECATED: Please use 'rm -r' instead.*
>>>>> *Deleted /user/hive/warehouse/mydatabase.db/mytable*
>>>>> *Failed with exception null*
>>>>> *FAILED: Execution Error, return code 1 from
>>>>> org.apache.hadoop.hive.ql.exec.MoveTask*
>>>>> *MapReduce Jobs Launched:*
>>>>> *Job 0: Map: 196  Reduce: 3   Cumulative CPU: 2311.26 sec   HDFS
>>>>> Read: 0 HDFS Write: 0 SUCCESS*
>>>>> *Total MapReduce CPU Time Spent: 38 minutes 31 seconds 260 msec*
>>>>>
>>>>> Does anyone have a clue how to resolve this?
>>>>>
>>>>> Best regards,
>>>>>
>>>>> Robin Verlangen
>>>>> *Software engineer*
>>>>> *
>>>>> *
>>>>> W http://www.robinverlangen.nl
>>>>> E [EMAIL PROTECTED]
>>>>>
>>>>> <http://goo.gl/Lt7BC>
>>>>>
>>>>> Disclaimer: The information contained in this message and attachments
>>>>> is intended solely for the attention and use of the named addressee and may
>>>>> be confidential. If you are not the intended recipient, you are reminded
>>>>> that the information remains the property of the sender. You must not use,
>>>>> disclose, distribute, copy, print or rely on this e-mail. If you have