Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # dev - hive failed execution error return code 2 from org.apache.hadoop.hive.ql.exec.mapredtask


Copy link to this message
-
Re: hive failed execution error return code 2 from org.apache.hadoop.hive.ql.exec.mapredtask
Mark Grover 2012-05-10, 13:33
Hi Bhavesh,
You will have to check your Jobtracker logs for more details. If you are using AWS, they should be in your S3 logs directory under
<job_flow_id>/daemons/<master_node_id>/hadoop-hadoop-jobtracker...log

Mark

Mark Grover, Business Intelligence Analyst
OANDA Corporation

www: oanda.com www: fxtrade.com

----- Original Message -----
From: "Bhavesh Shah" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Sent: Thursday, May 10, 2012 6:27:28 AM
Subject: hive failed execution error return code 2 from org.apache.hadoop.hive.ql.exec.mapredtask

Hello all,
I have one query. It is executing fine on Hive CLI and returning the result.
But when I am executing it with the help Hive JDBC I am getting error as:

java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:192)

What is the problem? Also I am starting the Hive Thrift Server through Shell Script. (I have written a shell script which has commad to start Hive Thrift Server)
Later I decided to start Hive thrift Server manually by typing command as:

hadoop@ubuntu:~/hive-0.7.1$ bin/hive --service hiveserver
Starting Hive Thrift Server
org.apache.thrift.transport.TTransportException: Could not create ServerSocket on address 0.0.0.0/0.0.0.0:10000 .
at org.apache.thrift.transport.TServerSocket.<init>(TServerSocket.java:99)
at org.apache.thrift.transport.TServerSocket.<init>(TServerSocket.java:80)
at org.apache.thrift.transport.TServerSocket.<init>(TServerSocket.java:73)
at org.apache.hadoop.hive.service.HiveServer.main(HiveServer.java:384)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.RunJar.main(RunJar.java:186)
hadoop@ubuntu:~/hive-0.7.1$

Please help me out from this.
Thanks
--
Regards,
Bhavesh Shah