Thank you for pointing me to the /tmp/root/hive.log, forgot about that one. The problem was caused by:
*Caused by: java.sql.SQLException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'* This happened because of enabling mysql binlog for replication. Didn't know that could co-relate to hive. Just disabled it for now. Thank you all for your time. 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/30 Shreepadma Venugopalan <shreepa...@cloudera.com> > 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 >> >> >> >
