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

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


+
Robin Verlangen 2012-10-29, 12:38
+
Chen Song 2012-10-29, 15:00
+
Robin Verlangen 2012-10-29, 16:02
+
Robin Verlangen 2012-10-29, 16:22
Copy link to this message
-
Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
Chen Song 2012-10-29, 17:19
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
>>>> received this message in error, please contact the sender immediately and
>>>> irrevocably delete this message and any copies.
>>>>
>>>>
>>>
>>>
>>> --
>>> Chen Song
>>>
>>>
>>>
>>
>
--
Chen Song
+
Shreepadma Venugopalan 2012-10-30, 00:36
+
Robin Verlangen 2012-10-30, 09:49
+
Josh Draner 2014-02-12, 03:06