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 <chen.song...@gmail.com> 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 <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 > > >
