install hive with RPM this is correpted!!!!!! On Wed, Oct 19, 2011 at 8:01 PM, Mark Kerzner <mark.kerz...@shmsoft.com>wrote:
> 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 >> > > -- With Regards Vikas Srivastava DWH & Analytics Team Mob:+91 9560885900 One97 | Let's get talking !
