hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bejoy...@yahoo.com
Subject Re: Hive query failing on group by
Date Wed, 19 Oct 2011 14:21:57 GMT
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.kerzner@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

Mime
View raw message