Re: Hive Query failing !!!

2015-09-22 Thread Nitin Pawar
Ok Sorry my bad I had overlooked your query that you are doing joins via where clause. On Tue, Sep 22, 2015 at 12:20 PM, @Sanjiv Singh wrote: > Nitin, > > Following setting already there at HIVE. > set hive.exec.mode.local.auto=false; > > Surprisingly , when it did following setting , it starte

Re: Hive Query failing !!!

2015-09-21 Thread @Sanjiv Singh
Nitin, Following setting already there at HIVE. set hive.exec.mode.local.auto=false; Surprisingly , when it did following setting , it started working set hive.auto.convert.join=true; can you please help me understand , what had happened ? Regards Sanjiv Singh Mob : +091 9990-447-339 O

Re: Hive Query failing !!!

2015-09-21 Thread Nitin Pawar
Can you try setting these set hive.exec.mode.local.auto=false; On Tue, Sep 22, 2015 at 11:25 AM, @Sanjiv Singh wrote: > > > *Hi Folks,* > > > *I am running given hive query . it is giving error while executing. > please help me get out of it and understand possible reason for error.* > > *Hive

Re: Hive query failing

2012-09-26 Thread Sarath
@Kulkarni, As suggested copied the JAR into the specified directory, now it is complaining as - /java.io.FileNotFoundException: File does not exist: /tmp/hduser/hive_2012-09-27_11-24-32_966_3932937489091919630/-mr-1/1/emptyFile/ where hduser is the unix login ID from where i'm executing the

Re: Hive query failing

2012-09-25 Thread Sarath
Somehow (by resetting folder permissions) I got rid of the below error. But now I'm getting a new error as below. Looks like I'm missing some configuration, but not sure what and where. /hive> select count(1) from table1; Total MapReduce jobs = 1 Launching Job 1 out of 1 Number of reduce tasks

Re: Hive query failing

2012-09-25 Thread kulkarni . swarnim
The jar is being looked on HDFS as the exception suggests. Run the following commands: $ hadoop fs -mkdir /usr/lib/hive/lib $ hadoop fs -put $HIVE_HOME/lib/hive-builtins-0.8.1-cdh4.0.1.jar /usr/lib/hive/lib Your queries should work now. On Sep 25, 2012, at 6:46 AM, Manish.Bhoge wrote: > Sara

RE: Hive query failing

2012-09-25 Thread Manish . Bhoge
Sarath, Is this the external table where you have ran the query? How did you loaded the table? Because it looks like the error is about the file related to table than CDH Jar. Thank You, Manish From: Sarath [mailto:sarathchandra.jos...@algofusiontech.com] Sent: Tuesday, September 25, 2012 3:4

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