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 <ro...@us2.nl> 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 ro...@us2.nl > > <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
