Re: Hive query failing on group by

2011-10-19 Thread Mark Kerzner
o: * user@hive.apache.org > *Subject: *Re: Hive query failing on group by > > Bejoy, > > I've been using this install of Hive for some time now, and simple queries > and joins work fine. It's the GROUP BY that I have problems with, sometimes > even with COUNT(*

Re: Hive query failing on group by

2011-10-19 Thread bejoy_ks
10:55:34 To: ; Reply-To: user@hive.apache.org Subject: Re: Hive query failing on group by Bejoy, I've been using this install of Hive for some time now, and simple queries and joins work fine. It's the GROUP BY that I have problems with, sometimes even with COUNT(*). I am trying to i

Re: Hive query failing on group by

2011-10-19 Thread Mark Kerzner
hat also looks good then you can kind of > confirm that the bug is with your hive query. > > We can look into that direction then. > > > > Regards > Bejoy K S > -- > *From: * Mark Kerzner > *Date: *Wed, 19 Oct 2011 10:02:57 -0500 > *To:

Re: Hive query failing on group by

2011-10-19 Thread bejoy_ks
Oct 2011 10:02:57 To: Reply-To: user@hive.apache.org Subject: Re: Hive query failing on group by 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

Re: Hive query failing on group by

2011-10-19 Thread Mark Kerzner
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 wrote: > >> Here is w

Re: Hive query failing on group by

2011-10-19 Thread Vikas Srivastava
install hive with RPM this is correpted!! On Wed, Oct 19, 2011 at 8:01 PM, Mark Kerzner 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" require

Re: Hive query failing on group by

2011-10-19 Thread Mark Kerzner
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 (Log

Re: Hive query failing on group by

2011-10-19 Thread bejoy_ks
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 fr