Hello, I am trying to run hive queries but I am getting errors as: hive> FROM ( > FROM t1 > MAP t1.patient_mrn, t1.encounter_date > USING 'retrieve' > AS mp1, mp2 > CLUSTER BY mp1) map_output > INSERT OVERWRITE TABLE t3 > REDUCE map_output.mp1, map_output.mp2 > USING 'q1.txt' > AS reducef1, reducef2; 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_0097, Tracking URL = http://localhost:50030/jobdetails.jsp?jobid=job_201112281627_0097 Kill Command = /home/hadoop/hadoop-0.20.2-cdh3u2//bin/hadoop job -Dmapred.job.tracker=localhost:54311 -kill job_201112281627_0097 2011-12-31 03:10:46,391 Stage-1 map = 0%, reduce = 0% 2011-12-31 03:11:29,794 Stage-1 map = 100%, reduce = 100% Ended Job = job_201112281627_0097 with errors FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask hive>
-- Regards, Bhavesh Shah