HI, I am trying to figure out what I am doing wrong with this query and the unusual error I am getting. Also suspicious is the reduce % going up and down.
select trans.property_id, day(trans.log_timestamp) from trans JOIN opts on trans.ext_booking_id["ext_booking_id"] = opts.ext_booking_id group by day(trans.log_timestamp), trans.property_id; 2011-10-19 08:55:19,778 Stage-1 map = 0%, reduce = 0% 2011-10-19 08:55:22,786 Stage-1 map = 100%, reduce = 0% 2011-10-19 08:55:29,804 Stage-1 map = 100%, reduce = 33% 2011-10-19 08:55:32,811 Stage-1 map = 100%, reduce = 0% 2011-10-19 08:55:39,829 Stage-1 map = 100%, reduce = 33% 2011-10-19 08:55:43,839 Stage-1 map = 100%, reduce = 0% 2011-10-19 08:55:50,855 Stage-1 map = 100%, reduce = 33% 2011-10-19 08:55:54,864 Stage-1 map = 100%, reduce = 0% 2011-10-19 08:56:00,878 Stage-1 map = 100%, reduce = 33% 2011-10-19 08:56:04,887 Stage-1 map = 100%, reduce = 0% 2011-10-19 08:56:05,891 Stage-1 map = 100%, reduce = 100% Ended Job = job_201110111849_0024 with errors FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask Thank you, Mark