Hi Mark
What does your Map reduce job logs say? Try figuring out the error form
there. From hive CLI you could hardly find out the root cause of your errors.
From job tracker web UI < http://hostname:50030/jobtracker.jsp> you can easily
browse to failed tasks and get the actual exception from there. If you are not
able to figure out from there then please post in those logs with your table
schema.
Regards
Bejoy K S
-----Original Message-----
From: Mark Kerzner <mark.kerz...@shmsoft.com>
Date: Wed, 19 Oct 2011 09:06:13
To: Hive user<user@hive.apache.org>
Reply-To: user@hive.apache.org
Subject: Hive query failing on group by
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
