Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB