Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

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 m

Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

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 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/h

Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

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 wrote: > I have to add, while trying to do other operation

Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

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

Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

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 Disclaimer: The information contained in this message and attachments is intended s

Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

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 wrote: > Hi there, > > Since today our Hive jobs suddenly fail (nothing changed actually)

Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

, Bejoy KS From: Gabriel Eisbruch To: "user@hive.apache.org" Sent: Thursday, August 2, 2012 7:01 AM Subject: Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask Hi Techy this error use to appeare when the user executi

Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

Hi Techy this error use to appeare when the user executing the query has not permisions into the origin or target folder, if you create a single table (no externa) is probable that you has not permissions to write into /user/hive Respect to your before question, i am using snappy to compress the d