Hello, This are my logs, related to my execution of Hive query. 2011-12-31 04:34:17,604 WARN mapred.JobClient (JobClient.java:copyAndConfigureFiles(649)) - Use GenericOptionsParser for parsing the arguments. Applications should implement Tool for the same. 2011-12-31 04:36:35,357 ERROR exec.MapRedTask (SessionState.java:printError(343)) - Ended Job = job_201112281627_0100 with errors 2011-12-31 04:36:38,112 ERROR ql.Driver (SessionState.java:printError(343)) - FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask 2011-12-31 05:37:34,750 WARN mapred.JobClient (JobClient.java:copyAndConfigureFiles(649)) - Use GenericOptionsParser for parsing the arguments. Applications should implement Tool for the same. 2011-12-31 05:42:58,176 ERROR exec.MapRedTask (SessionState.java:printError(343)) - Ended Job = job_201112281627_0101 with errors 2011-12-31 05:43:16,748 ERROR ql.Driver (SessionState.java:printError(343)) - FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask 2011-12-31 06:40:31,764 WARN mapred.JobClient (JobClient.java:copyAndConfigureFiles(649)) - Use GenericOptionsParser for parsing the arguments. Applications should implement Tool for the same. 2011-12-31 06:55:22,527 WARN mapred.JobClient (JobClient.java:copyAndConfigureFiles(649)) - Use GenericOptionsParser for parsing the arguments. Applications should implement Tool for the same. 2011-12-31 07:00:08,695 ERROR exec.MapRedTask (SessionState.java:printError(343)) - Ended Job = job_201112281627_0103 with errors 2011-12-31 07:00:12,374 ERROR ql.Driver (SessionState.java:printError(343)) - FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask 2011-12-31 07:08:21,565 WARN mapred.JobClient (JobClient.java:copyAndConfigureFiles(649)) - Use GenericOptionsParser for parsing the arguments. Applications should implement Tool for the same. 2011-12-31 07:10:23,405 ERROR exec.MapRedTask (SessionState.java:printError(343)) - Ended Job = job_201112281627_0104 with errors 2011-12-31 07:10:25,006 ERROR ql.Driver (SessionState.java:printError(343)) - FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask 2011-12-31 07:17:48,490 WARN mapred.JobClient (JobClient.java:copyAndConfigureFiles(649)) - Use GenericOptionsParser for parsing the arguments. Applications should implement Tool for the same.
Pls tell me what to do te remove this error. -- Regards, Bhavesh Shah On Fri, Jan 6, 2012 at 10:44 PM, Aniket Mokashi <aniket...@gmail.com> wrote: > [moving to user@hive] > > Can you send us the details from task logs? > > Thanks, > Aniket > > On Fri, Jan 6, 2012 at 2:53 AM, Bhavesh Shah <bhavesh25s...@gmail.com > >wrote: > > > Hello, > > > > hive> FROM ( > > > FROM subset > > > MAP subset.patient_mrn, subset.encounter_date > > > USING 'q1.txt' > > > AS mp1, mp2 > > > CLUSTER BY mp1) map_output > > > INSERT OVERWRITE TABLE t3 > > > REDUCE map_output.mp1 > > > USING 'retrieve' > > > AS reducef1; > > Total MapReduce jobs = 1 > > Launching Job 1 out of 1 > > Number of reduce tasks not specified. Estimated from input data size: 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_201112281627_0100, Tracking URL = > > http://localhost:50030/jobdetails.jsp?jobid=job_201112281627_0100 > > Kill Command = /home/hadoop/hadoop-0.20.2-cdh3u2//bin/hadoop job > > -Dmapred.job.tracker=localhost:54311 -kill job_201112281627_0100 > > 2011-12-31 04:34:52,208 Stage-1 map = 0%, reduce = 0% > > 2011-12-31 04:35:52,939 Stage-1 map = 0%, reduce = 0% > > 2011-12-31 04:36:34,097 Stage-1 map = 100%, reduce = 100% > > Ended Job = job_201112281627_0100 with errors > > FAILED: Execution Error, return code 2 from > > org.apache.hadoop.hive.ql.exec.MapRedTask > > hive> > > > > In 'q1.txt' I have written query in Hive which returns 2 columns > > and > > In 'retrieve' I have wriiten a java code which takes 2 input and display > > the 1 column > > > > Is there any mistake in query. > > > > > > Pls suggest me some solution. > > > > > > -- > > Regards, > > Bhavesh Shah > > > > > > -- > "...:::Aniket:::... Quetzalco@tl" >
