Vikas, I am using Cloudera CDHU1 on Ubuntu. I get the same results on RedHat CDHU0.
Mark On Wed, Oct 19, 2011 at 9:47 AM, Vikas Srivastava < vikas.srivast...@one97.net> wrote: > 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 ! > >
