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.comwrote:
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