errors while running hive queries

[Bhavesh Shah <bh...@gmail.com>]

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