Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask MapReduce Jobs Launched:


Copy link to this message
-
RE: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask MapReduce Jobs Launched:
You are correct.

I have run two commands,

1) select site_id from site where id = 2;

it shows result and details are.

Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_201207241536_0003, Tracking URL = http://localhost:50030/jobdetails.jsp?jobid=job_201207241536_0003
Kill Command = /HADOOP/hadoop-0.20.2/bin/../bin/hadoop job  -Dmapred.job.tracker=localhost:9001 -kill job_201207241536_0003
Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 0
2012-07-24 15:42:09,251 Stage-1 map = 0%,  reduce = 0%
2012-07-24 15:42:12,332 Stage-1 map = 100%,  reduce = 0%
2012-07-24 15:42:15,391 Stage-1 map = 100%,  reduce = 100%
Ended Job = job_201207241536_0003
MapReduce Jobs Launched:
Job 0: Map: 1   HDFS Read: 24 HDFS Write: 3 SUCESS
Total MapReduce CPU Time Spent: 0 msec
OK
12
Time taken: 17.696 seconds

When I have no reduce operator it works fine, but in second case.
2) select count(*) from site;

Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
  set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
  set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
  set mapred.reduce.tasks=<number>
Starting Job = job_201207241536_0002, Tracking URL = http://localhost:50030/jobdetails.jsp?jobid=job_201207241536_0002
Kill Command = /HADOOP/hadoop-0.20.2/bin/../bin/hadoop job  -Dmapred.job.tracker=localhost:9001 -kill job_201207241536_0002
Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 1
2012-07-24 15:37:53,818 Stage-1 map = 0%,  reduce = 0%
2012-07-24 15:38:00,176 Stage-1 map = 100%,  reduce = 0%
2012-07-24 15:39:01,068 Stage-1 map = 100%,  reduce = 0%
2012-07-24 15:39:03,307 Stage-1 map = 100%,  reduce = 100%
Ended Job = job_201207241536_0002 with errors
Error during job, obtaining debugging information...
Examining task ID: task_201207241536_0002_m_000002 (and more) from job job_201207241536_0002
Exception in thread "Thread-40" java.lang.RuntimeException: Error while reading from task log url
    at org.apache.hadoop.hive.ql.exec.errors.TaskLogProcessor.getErrors(TaskLogProcessor.java:130)
    at org.apache.hadoop.hive.ql.exec.JobDebugger.showJobFailDebugInfo(JobDebugger.java:211)
    at org.apache.hadoop.hive.ql.exec.JobDebugger.run(JobDebugger.java:81)
    at java.lang.Thread.run(Thread.java:680)
Caused by: java.io.IOException: Server returned HTTP response code: 407 for URL: http://10.203.33.81:50060/tasklog?taskid=attempt_201207241536_0002_r_000000_0&start=-8193
    at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1436)
    at java.net.URL.openStream(URL.java:1010)
    at org.apache.hadoop.hive.ql.exec.errors.TaskLogProcessor.getErrors(TaskLogProcessor.java:120)
    ... 3 more
FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
MapReduce Jobs Launched:
Job 0: Map: 1  Reduce: 1   HDFS Read: 24 HDFS Write: 0 FAIL
Total MapReduce CPU Time Spent: 0 msec

When I have Reduce operator it gets fail.
 
Please suggest how do I make all nodes free from security issues and n/w proxy.
This is offc's machine (Mac OS X 10.6.8).

Thanks & Regards
Yogesh Kumar
8147912904
________________________________________
From: Nitin Pawar [[EMAIL PROTECTED]]
Sent: Tuesday, July 24, 2012 2:13 PM
To: [EMAIL PROTECTED]
Subject: Re: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask MapReduce Jobs Launched:

yogesh,
is your network setup with proxy authentication? normally the error
which you are getting is, when a node tries to connect to another node
but then after some time, the connection needs to be reauthorized.

when you do a select * from table, it does not launch a MR, it just
does a dfs -cat of the hdfs file

you will need to check the cluster health of your hadoop cluster. Also
make sure that on all the nodes the default linux security is off
(iptables )

On Tue, Jul 24, 2012 at 2:09 PM,  <[EMAIL PROTECTED]> wrote:

Nitin Pawar

Please do not print this email unless it is absolutely necessary.

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

www.wipro.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB