Re: Need urgent help

2014-07-02 Thread Nagarjuna Vissarapu
set dfs.permissions property as false and try once. On Wed, Jul 2, 2014 at 12:42 PM, wrote: > Yes. > > > Sent from Samsung Mobile > > > Original message > From: Andre Araujo > Date:02/07/2014 00:10 (GMT-08:00) > To: user > Subject: Re: Nee

Re: Need urgent help

2014-07-02 Thread shouvanik.haldar
Yes. Sent from Samsung Mobile Original message From: Andre Araujo Date:02/07/2014 00:10 (GMT-08:00) To: user Subject: Re: Need urgent help Did you manage to load the jar from the local file? On 2 July 2014 16:57, mailto:shouvanik.hal...@accenture.com>> wrote: Thi

Re: Need urgent help

2014-07-02 Thread Andre Araujo
0) > To: user > Subject: Re: Need urgent help > > Can you try the following to check if there's any problem with the jar > itself? > > hadoop fs -copyToLocal > hdfs://xx.xx.xx.xxx:9000/user/ipg_intg_user/AP/scripts/lib/wsaUtils.jar > /tmp/ > > hive>

Re: Need urgent help

2014-07-01 Thread shouvanik.haldar
This copy was successful. The file was not corrupted Sent from Samsung Mobile Original message From: Andre Araujo Date:01/07/2014 23:45 (GMT-08:00) To: user Subject: Re: Need urgent help Can you try the following to check if there's any problem with the jar itself? h

Re: Need urgent help

2014-07-01 Thread Andre Araujo
supergroup 621942 2014-05-20 21:33 > hdfs://xx.xx.xx.xxx:9000/user/ipg_intg_user/AP/scripts/lib/wsaUtils.jar > > > > *From:* Andre Araujo [mailto:ara...@pythian.com] > *Sent:* Tuesday, July 01, 2014 10:46 PM > *To:* user > > *Subject:* Re: Need urgent help > >

RE: Need urgent help

2014-07-01 Thread shouvanik.haldar
-rw-r--r-T 1 ipg_intg_user supergroup 621942 2014-05-20 21:33 hdfs://xx.xx.xx.xxx:9000/user/ipg_intg_user/AP/scripts/lib/wsaUtils.jar From: Andre Araujo [mailto:ara...@pythian.com] Sent: Tuesday, July 01, 2014 10:46 PM To: user Subject: Re: Need urgent help What's the result o

Re: Need urgent help

2014-07-01 Thread Andre Araujo
Query returned non-zero code: 1, cause: > hdfs://xx.xx.xx.xxx:9000/user/ipg_intg_user/AP/scripts/lib/wsaUtils.jar > does not exist. > > > > > > > > > > *From:* hadoop hive [mailto:hadooph...@gmail.com] > *Sent:* Tuesday, July 01, 2014 8:58 PM > *To:* user@hi

Re: Need urgent help

2014-07-01 Thread shouvanik.haldar
Yes Sent from Samsung Mobile Original message From: Abirami V Date:01/07/2014 22:15 (GMT-08:00) To: user@hive.apache.org Subject: Re: Need urgent help Hi, have you add the property in hive( hive.aux.jars.path. The location of the plugin jars that contain implementations

Re: Need urgent help

2014-07-01 Thread Abirami V
t; >> Shouvanik >> >> >> >> *From:* hadoop hive [mailto:hadooph...@gmail.com] >> *Sent:* Tuesday, July 01, 2014 9:45 PM >> *To:* user@hive.apache.org >> *Subject:* RE: Need urgent help >> >> >> >> Jar must have read permission by th

RE: Need urgent help

2014-07-01 Thread hadoop hive
.@gmail.com] > *Sent:* Tuesday, July 01, 2014 9:45 PM > *To:* user@hive.apache.org > *Subject:* RE: Need urgent help > > > > Jar must have read permission by that user. Which you are using to run the > jobs. > > On Jul 2, 2014 9:37 AM, wrote: > > Can you plea

RE: Need urgent help

2014-07-01 Thread shouvanik.haldar
The user has read permission Its rw-r—r— Thanks, Shouvanik From: hadoop hive [mailto:hadooph...@gmail.com] Sent: Tuesday, July 01, 2014 9:45 PM To: user@hive.apache.org Subject: RE: Need urgent help Jar must have read permission by that user. Which you are using to run the jobs. On Jul 2, 2014

RE: Need urgent help

2014-07-01 Thread hadoop hive
xx.xxx:9000/user/ipg_intg_user/AP/scripts/lib/wsaUtils.jar > does not exist. > > > > > > > > > > *From:* hadoop hive [mailto:hadooph...@gmail.com] > *Sent:* Tuesday, July 01, 2014 8:58 PM > *To:* user@hive.apache.org > *Subject:* Re: Need urgent help > &

RE: Need urgent help

2014-07-01 Thread shouvanik.haldar
/AP/scripts/lib/wsaUtils.jar Query returned non-zero code: 1, cause: hdfs://xx.xx.xx.xxx:9000/user/ipg_intg_user/AP/scripts/lib/wsaUtils.jar does not exist. From: hadoop hive [mailto:hadooph...@gmail.com] Sent: Tuesday, July 01, 2014 8:58 PM To: user@hive.apache.org Subject: Re: Need urgent h

Recall: Need urgent help

2014-07-01 Thread shouvanik.haldar
Haldar, Shouvanik would like to recall the message, "Need urgent help". This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify

Recall: Need urgent help

2014-07-01 Thread shouvanik.haldar
Haldar, Shouvanik would like to recall the message, "Need urgent help". This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify

Re: Need urgent help

2014-07-01 Thread Jagat Singh
Hi, Is the user which is running query having rights to access the file. Thanks On Wed, Jul 2, 2014 at 1:51 PM, wrote: > Hi, > > Cannot add a jar to hive classpath. > > Once I launch HIVE, I type -> ADD JAR hdfs://10.37.83.117 > :9000/user/ipg_intg_user/AP/scripts/lib/wsaUtils.jar; > > > > I

Re: Need urgent help

2014-07-01 Thread hadoop hive
Check the permission and validate if jar is not corrupted. Apart from that you can put this jar inside in hive lib directory, that will be automatically read by hive. Thanks Vikas Srivastava On Jul 2, 2014 9:21 AM, wrote: > Hi, > > Cannot add a jar to hive classpath. > > Once I launch HIVE, I

Need urgent help

2014-07-01 Thread shouvanik.haldar
Hi, Cannot add a jar to hive classpath. Once I launch HIVE, I type -> ADD JAR hdfs://10.37.83.117:9000/user/ipg_intg_user/AP/scripts/lib/wsaUtils.jar; I get the error, Failed to read external resource hdfs://10.37.83.117:9000/user/ipg_intg_user/AP/scripts/lib/wsaUtils.jar Query returned non-zero

RE: Need urgent help on hive query performance

2014-06-01 Thread shouvanik.haldar
urgency. Thanks, Shouvanik From: Bala Krishna Gangisetty [mailto:b...@altiscale.com] Sent: Friday, May 30, 2014 4:08 PM To: user@hive.apache.org Subject: Re: Need urgent help on hive query performance Another dimension, Try storing Hive table in ORC format. From my experience, it significantly

Re: Need urgent help on hive query performance

2014-05-30 Thread Bala Krishna Gangisetty
com [mailto:kulkarni.swar...@gmail.com] >> *Sent:* Friday, May 30, 2014 3:34 PM >> >> *To:* user@hive.apache.org >> *Subject:* Re: Need urgent help on hive query performance >> >> >> >> I feel it's pretty hard to answer this without understanding th

Re: Need urgent help on hive query performance

2014-05-30 Thread kulkarni.swar...@gmail.com
nswers > > > > > > > > *From:* kulkarni.swar...@gmail.com [mailto:kulkarni.swar...@gmail.com] > *Sent:* Friday, May 30, 2014 3:34 PM > > *To:* user@hive.apache.org > *Subject:* Re: Need urgent help on hive query performance > > > > I feel it's pre

RE: Need urgent help on hive query performance

2014-05-30 Thread shouvanik.haldar
Pls find the answers From: kulkarni.swar...@gmail.com [mailto:kulkarni.swar...@gmail.com] Sent: Friday, May 30, 2014 3:34 PM To: user@hive.apache.org Subject: Re: Need urgent help on hive query performance I feel it's pretty hard to answer this without understanding the following

Re: Need urgent help on hive query performance

2014-05-30 Thread Ashish Garg
7;; This will optimize your query performance. On Fri, May 30, 2014 at 6:32 PM, wrote: > Can you please give a specific example or blog to refer to. I did not > understand > > > > *From:* Ashish Garg [mailto:gargcreation1...@gmail.com] > *Sent:* Friday, May 30, 2014 3:31 PM

Re: Need urgent help on hive query performance

2014-05-30 Thread kulkarni.swar...@gmail.com
g [mailto:gargcreation1...@gmail.com] > *Sent:* Friday, May 30, 2014 3:31 PM > *To:* user@hive.apache.org > *Subject:* Re: Need urgent help on hive query performance > > > > try partitioning the table and run the queries which are partition > specific. Hope this helps. > > Thanks

RE: Need urgent help on hive query performance

2014-05-30 Thread shouvanik.haldar
Can you please give a specific example or blog to refer to. I did not understand From: Ashish Garg [mailto:gargcreation1...@gmail.com] Sent: Friday, May 30, 2014 3:31 PM To: user@hive.apache.org Subject: Re: Need urgent help on hive query performance try partitioning the table and run the

Re: Need urgent help on hive query performance

2014-05-30 Thread Ashish Garg
try partitioning the table and run the queries which are partition specific. Hope this helps. Thanks and Regards, Ashish Garg. On Fri, May 30, 2014 at 6:05 PM, wrote: > Hi, > > > > Does anybody help urgently on optimizing hive query performance? I am > looking more Hadoop tuning point of view

Need urgent help on hive query performance

2014-05-30 Thread shouvanik.haldar
Hi, Does anybody help urgently on optimizing hive query performance? I am looking more Hadoop tuning point of view. Currently, small amount of table takes much time to query? We are running EMR cluster with 1 MASTER node, 2 Core Nodes and Task Nodes. Quick help is much appreciated. Thanks,

Re: Need urgent help in hive query

2013-07-02 Thread dyuti a
rk; second, optimize. > > Robin > > From: dyuti a > Reply-To: "user@hive.apache.org" > Date: Friday, June 28, 2013 12:05 PM > To: "user@hive.apache.org" > Subject: Re: Need urgent help in hive query > > Hi Robin, > Thanks for your reply. H

Re: Need urgent help in hive query

2013-06-28 Thread Robin Morris
.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Date: Friday, June 28, 2013 12:05 PM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: Re: Need urgent help in hive query Hi Robin, Thanks for yo

Re: Need urgent help in hive query

2013-06-28 Thread dyuti a
query on that, then drop the temporary table. > > Robin > > From: dyuti a > Reply-To: "user@hive.apache.org" > Date: Friday, June 28, 2013 10:54 AM > To: "user@hive.apache.org" , Michael Malak < > michaelma...@yahoo.com> > Subject: Re: Fwd

Re: Need urgent help in hive query

2013-06-28 Thread Robin Morris
t;> Date: Friday, June 28, 2013 10:54 AM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>>, Michael Malak mailto:michaelma...@yahoo.com>> Subject: Re: Fwd: Need urgent help in hive query Hi Michael, Thanks for your help, is there any

Re: Fwd: Need urgent help in hive query

2013-06-28 Thread dyuti a
> *To:* user@hive.apache.org > *Sent:* Friday, June 28, 2013 10:58 AM > *Subject:* Fwd: Need urgent help in hive query > > Hi Experts, > I'm trying with the below SQL query in Hive, which does not support column > alias access in subsequent columns as shown below in the query. I

Re: Fwd: Need urgent help in hive query

2013-06-28 Thread Michael Malak
Just copy and paste the whole long expressions to their second occurrences. From: dyuti a To: user@hive.apache.org Sent: Friday, June 28, 2013 10:58 AM Subject: Fwd: Need urgent help in hive query Hi Experts, I'm trying with the below SQL query in

Fwd: Need urgent help in hive query

2013-06-28 Thread dyuti a
Hi Experts, I'm trying with the below SQL query in Hive, which does not support column alias access in subsequent columns as shown below in the query. Is there any other way to rewrite the same without using alias? any of your help are really appreciated. INSERT INTO CAUD ( pst_cc pst_no