The below information is not enough to figure out what is going on. Send the correct stack trace from /tmp/<user-name>/hive.log
You can change the log level to DEBUG in log4j.properties and rerun the query. Also if the mappers/reducers are failing then check the log of the failed tasks from hadoop. Prasad ________________________________ From: Keven Chen <[email protected]> Reply-To: <[email protected]> Date: Fri, 24 Jul 2009 17:57:08 -0700 To: <[email protected]> Subject: error code 2 I wrote a simple program to a query to pull some information from the database. There is only one query is called with different parameters. It was going fine at the beginning. However, it gives exceptions when the query is executed many times. (around 70 times) Here is the error infomation: 09/07/24 17:51:31 ERROR exec.ExecDriver: Ended Job = job_200907241124_0084 with errors FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver 09/07/24 17:51:31 ERROR ql.Driver: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver Does anyone know what is the problem? -- Thank you, Keven Chen
