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 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. 2012/10/29 Chen Song <chen.song...@gmail.com> > 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 > > >