Here is what my hive logs say hive -hiveconf hive.root.logger=DEBUG
2011-10-19 09:24:35,148 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.core.resources" but it cannot be resolved. 2011-10-19 09:24:35,150 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.core.runtime" but it cannot be resolved. 2011-10-19 09:24:35,150 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.text" but it cannot be resolved. On Wed, Oct 19, 2011 at 9:21 AM, <bejoy...@yahoo.com> wrote: > ** 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 > ------------------------------ > *From: * Mark Kerzner <mark.kerz...@shmsoft.com> > *Date: *Wed, 19 Oct 2011 09:06:13 -0500 > *To: *Hive user<user@hive.apache.org> > *ReplyTo: * 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 >
