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 <ro...@us2.nl> 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 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 Robin Verlangen <ro...@us2.nl> > >> 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 >>> >>> >>> >> > -- Chen Song
