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

Hive Query failing !!!

2015-09-21 Thread @Sanjiv Singh
*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 Query :* SELECT * FROM store_sales , date_dim , store , household_demographics , customer_address WHERE store_sales.

Re: Hive query failing

2012-09-26 Thread Sarath
ery? 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:48 PM *To:* user@hive.apache.org <mailto:user@hive.apache.o

Re: Hive query failing

2012-09-25 Thread Sarath
Tuesday, September 25, 2012 3:48 PM *To:* user@hive.apache.org <mailto:user@hive.apache.org> *Subject:* Hive query failing Hi, When I run the query "select count(1) from table1;" it fails with the exception message as below. /java.io.FileNotFoundException: File does not exist: /u

Re: Hive query failing

2012-09-25 Thread kulkarni . swarnim
siontech.com] > Sent: Tuesday, September 25, 2012 3:48 PM > To: user@hive.apache.org > Subject: Hive query failing > > Hi, > > When I run the query "select count(1) from table1;" it fails with the > exception message as below. > > java.io.FileNotFoundEx

RE: Hive query failing

2012-09-25 Thread Manish . Bhoge
:48 PM To: user@hive.apache.org Subject: Hive query failing Hi, When I run the query "select count(1) from table1;" it fails with the exception message as below. java.io.FileNotFoundException: File does not exist: /usr/lib/hive/lib/hive-builtins-0.8.1-cdh4.0.1.

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
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 >>> *Dat

Re: Hive query failing on group by

2011-10-19 Thread Vikas Srivastava
ctual 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 >> *Date: *Wed, 19 Oct 2011 09:

Re: Hive query failing on group by

2011-10-19 Thread Mark Kerzner
-- > *From: * Mark Kerzner > *Date: *Wed, 19 Oct 2011 09:06:13 -0500 > *To: *Hive user > *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 err

Re: Hive query failing on group by

2011-10-19 Thread bejoy_ks
eption 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 -Original Message- From: Mark Kerzner Date: Wed, 19 Oct 2011 09:06:13 To: Hive user Reply-To: user@hive.apache.org Subject: Hive query failing on gr

Hive query failing on group by

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

HIve query failing on MapReduce with no logs at all

2011-05-23 Thread Ayon Sinha
Hi, I created a table in HIVE prompt from files in the HDFS. I can see the table and can perform a select * query (which I believe does not need to do a MR). But for any query that needs MR, it submits the job, I can see it in Jobtracker and in 6 secs, all mappers & reducers are killed with no l