Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A2F971129C for ; Wed, 2 Jul 2014 07:13:07 +0000 (UTC) Received: (qmail 3054 invoked by uid 500); 2 Jul 2014 07:13:06 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 2989 invoked by uid 500); 2 Jul 2014 07:13:06 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 2979 invoked by uid 99); 2 Jul 2014 07:13:06 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Jul 2014 07:13:06 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS,T_FILL_THIS_FORM_SHORT X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of shouvanik.haldar@accenture.com designates 207.46.163.26 as permitted sender) Received: from [207.46.163.26] (HELO co9outboundpool.messaging.microsoft.com) (207.46.163.26) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Jul 2014 07:13:02 +0000 Received: from mail180-co9-R.bigfish.com (10.236.132.253) by CO9EHSOBE013.bigfish.com (10.236.130.76) with Microsoft SMTP Server id 14.1.225.22; Wed, 2 Jul 2014 07:12:36 +0000 Received: from mail180-co9 (localhost [127.0.0.1]) by mail180-co9-R.bigfish.com (Postfix) with ESMTP id 3BAFBB003C0 for ; Wed, 2 Jul 2014 07:12:36 +0000 (UTC) X-Forefront-Antispam-Report: CIP:170.252.38.69;KIP:(null);UIP:(null);IPV:NLI;H:EMEXE4005.dir.svc.accenture.com;RD:emexe4005.accenture.com;EFVD:NLI X-SpamScore: 1 X-BigFish: VPS1(z555eh3b4ckzbb2dI98dI9371Ic89bh936eIc85ehe0eah4015I853kzz1f42h1ee6h1de0h2073h2146h1202h1e76h2189h1d1ah1d2ah21bch21a7h1fc6h208ch1fdahzebhz1de098h17326ah8275bh8275dh18c673h1de097h186068h1954cbh18602ehz2fh109h2a8h839hd24hf0ah1288h12a5h12bdh137ah1441h1504h1537h153bh162dh1631h1758h18deh18e1h1946h19b5h1b0ah1bceh224fh1d0ch1d2eh1d3fh1dfeh1dffh1e1dh1fe8h1ff5h20f0h21a6h2216h22d0h2336h2438h2461h2487h24ach24d7h2516h2534h2545h255eh25f6h2605h268bh26d3h27e2h29d0h2a24h) Received-SPF: pass (mail180-co9: domain of accenture.com designates 170.252.38.69 as permitted sender) client-ip=170.252.38.69; envelope-from=shouvanik.haldar@accenture.com; helo=EMEXE4005.dir.svc.accenture.com ;ccenture.com ; Received: from mail180-co9 (localhost.localdomain [127.0.0.1]) by mail180-co9 (MessageSwitch) id 1404285154842508_7454; Wed, 2 Jul 2014 07:12:34 +0000 (UTC) Received: from CO9EHSMHS029.bigfish.com (unknown [10.236.132.247]) by mail180-co9.bigfish.com (Postfix) with ESMTP id CA6CCB8004C for ; Wed, 2 Jul 2014 07:12:34 +0000 (UTC) Received: from EMEXE4005.dir.svc.accenture.com (170.252.38.69) by CO9EHSMHS029.bigfish.com (10.236.130.39) with Microsoft SMTP Server (TLS) id 14.16.227.3; Wed, 2 Jul 2014 07:12:32 +0000 Received: from EMEXH4006.dir.svc.accenture.com (10.134.3.46) by EMEXE4005.dir.svc.accenture.com (10.134.4.195) with Microsoft SMTP Server id 14.3.158.1; Wed, 2 Jul 2014 09:12:02 +0200 Received: from email.accenture.com (170.248.176.28) by EMEXH4006.dir.svc.accenture.com (10.134.3.96) with Microsoft SMTP Server (TLS) id 14.3.181.6; Wed, 2 Jul 2014 09:12:01 +0200 Received: from 048-CH1MPN3-351.048d.mgd.msft.net ([fe80::60c6:19d8:17d3:87bd]) by 048-CH1MMR1-015.048d.mgd.msft.net ([170.248.176.28]) with mapi id 14.03.0181.007; Wed, 2 Jul 2014 07:12:00 +0000 From: To: Subject: Re: Need urgent help Thread-Topic: Need urgent help Thread-Index: Ac+VqEWWTtvWWGtJQ4+sVVMcR+huMAAAXpkAAABIdCAAA4WjgAAAgihAAAF/yQAAAHySJAAAaJwAAAAVfj0= Date: Wed, 2 Jul 2014 07:12:00 +0000 Message-ID: References: , In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: Content-Type: multipart/alternative; boundary="_000_x4gxeus3b6nxh0hlll9ewfg91404285117846emailandroidcom_" MIME-Version: 1.0 X-OrganizationHeadersPreserved: EMEXH4006.dir.svc.accenture.com X-CrossPremisesHeadersFiltered: EMEXE4005.dir.svc.accenture.com X-MS-Exchange-CrossPremises-OriginalArrivalTime: 02 Jul 2014 07:12:02.1994 (UTC) X-MS-Exchange-CrossPremises-OriginalClientIPAddress: 10.134.3.46 X-MS-Exchange-CrossPremises-OriginalServerIPAddress: 10.134.4.195 X-MS-Exchange-CrossPremises-AuthSource: EMEXE4005.dir.svc.accenture.com X-MS-Exchange-CrossPremises-AuthAs: Internal X-MS-Exchange-CrossPremises-AuthMechanism: 10 X-MS-Exchange-CrossPremises-MessageDirectionality: Originating X-MS-Exchange-CrossPremises-MessageScope: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossPremises-Cross-Premises-Headers-Processed: EMEXE4005.dir.svc.accenture.com X-MS-Exchange-CrossPremises-OriginalSize: 22784 X-MS-Exchange-CrossPremises-HygienePolicy: Standard X-OrganizationHeadersPreserved: EMEXE4005.dir.svc.accenture.com X-OriginatorOrg: accenture.com X-FOPE-CONNECTOR: Id%0$Dn%*$RO%0$TLS%0$FQDN%$TlsDn% X-Virus-Checked: Checked by ClamAV on apache.org --_000_x4gxeus3b6nxh0hlll9ewfg91404285117846emailandroidcom_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable 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, > wrote: 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 itse= lf? hadoop fs -copyToLocal hdfs://xx.xx.xx.xxx:9000/user/ipg_intg_user/AP/scrip= ts/lib/wsaUtils.jar /tmp/ hive> add jar file:///tmp/wsaUtils.jar; On 2 July 2014 16:01, > wrote: -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:araujo@pythian.com] Sent: Tuesday, July 01, 2014 10:46 PM To: user Subject: Re: Need urgent help What's the result of the command below? hadoop fs -ls hdfs://xx.xx.xx.xxx:9000/user/ipg_intg_user/AP/scripts/lib/ws= aUtils.jar On 2 July 2014 14:07, > wrote: Can you please elaborate on the permission Hi, Cannot add a jar to hive classpath. Once I launch HIVE, I type -> ADD JAR hdfs://xx.xx.xx.xxx:9000/user/ipg_int= g_user/AP/scripts/lib/wsaUtils.jar; I get the error, Failed to read external resource hdfs://xx.xx.xx.xxx:9000/user/ipg_intg_use= r/AP/scripts/lib/wsaUtils.jar Query returned non-zero code: 1, cause: hdfs://xx.xx.xx.xxx:9000/user/ipg_i= ntg_user/AP/scripts/lib/wsaUtils.jar does not exist. From: hadoop hive [mailto:hadoophive@gmail.com= ] Sent: Tuesday, July 01, 2014 8:58 PM To: user@hive.apache.org Subject: Re: Need urgent help Check the permission and validate if jar is not corrupted. Apart from that you can put this jar inside in hive lib directory, that wil= l be automatically read by hive. Thanks Vikas Srivastava On Jul 2, 2014 9:21 AM, > wrote: But when I do fs =96ls /user/ipg_intg_user/AP/scripts/lib/ , I am able to see the JAR fil= e. Please help. Thanks, Shouvanik ________________________________ This message is for the designated recipient only and may contain privilege= d, proprietary, or otherwise confidential information. If you have received= it in error, please notify the sender immediately and delete the original.= Any other use of the e-mail by you is prohibited. Where allowed by local l= aw, electronic communications with Accenture and its affiliates, including = e-mail and instant messaging (including content), may be scanned by our sys= tems for the purposes of information security and assessment of internal co= mpliance with Accenture policy. ___________________________________________________________________________= ___________ www.accenture.com -- Andr=E9 Ara=FAjo Big Data Consultant/Solutions Architect The Pythian Group - Australia - www.pythian.com Office (calls from within Australia): 1300 366 021 x1270 Office (international): +61 2 8016 7000 x270 OR +1 613 565 8696 x1270 Mobile: +61 410 323 559 Fax: +61 2 9805 0544 IM: pythianaraujo @ AIM/MSN/Y! or araujo@pythian.com @ GTalk =93Success is not about standing at the top, it's the steps you leave behin= d.=94 =97 Iker Pou (rock climber) -- -- Andr=E9 Ara=FAjo Big Data Consultant/Solutions Architect The Pythian Group - Australia - www.pythian.com Office (calls from within Australia): 1300 366 021 x1270 Office (international): +61 2 8016 7000 x270 OR +1 613 565 8696 x1270 Mobile: +61 410 323 559 Fax: +61 2 9805 0544 IM: pythianaraujo @ AIM/MSN/Y! or araujo@pythian.com @ GTalk =93Success is not about standing at the top, it's the steps you leave behin= d.=94 =97 Iker Pou (rock climber) -- -- Andr=E9 Ara=FAjo Big Data Consultant/Solutions Architect The Pythian Group - Australia - www.pythian.com Office (calls from within Australia): 1300 366 021 x1270 Office (international): +61 2 8016 7000 x270 OR +1 613 565 8696 x1270 Mobile: +61 410 323 559 Fax: +61 2 9805 0544 IM: pythianaraujo @ AIM/MSN/Y! or araujo@pythian.com @ GTalk =93Success is not about standing at the top, it's the steps you leave behin= d.=94 =97 Iker Pou (rock climber) -- --_000_x4gxeus3b6nxh0hlll9ewfg91404285117846emailandroidcom_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
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, <shouvanik.h= aldar@accenture.com> wrote:
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?

hadoop fs -copyToLocal hdfs://xx.xx.xx.xxx:9000/user/ipg_intg_user/AP/= scripts/lib/wsaUtils.jar /tmp/

hive> add jar file:///tmp/wsaUtils.jar;


On 2 July 2014 16:01, <shouvanik.h= aldar@accenture.com> wrote:

-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<= /u>

 

From: Andre = Araujo [mailto:arau= jo@pythian.com]
Sent: Tuesday, July 01, 2014 10:46 PM
To: user


Subject: Re: Need urgent help

 

What's the result of the command below?

 

hadoop fs -ls hdfs://xx.xx.xx.xxx:9000/user/ipg_intg= _user/AP/scripts/lib/wsaUtils.jar

 <= /p>

On 2 July 2014 14:07, <shouvanik.haldar@accenture.com> wrote:

Can you please elaborat= e on the permission

 =

 =

Hi,

Cannot add a jar to hive classpath.

Once I launch HIVE, I type -> ADD JAR hdfs://xx.x= x.xx.xxx:9000/user/ipg_intg_user/AP/scripts/lib/wsaUtils.jar;=

 

I get the error,

Failed to read external resource hdfs://xx.xx.xx.xxx:9000/user/ipg_intg_user/AP/script= s/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:had= oophive@gmail.com]
Sent: Tuesday, July 01, 2014 8:58 PM
To: user@h= ive.apache.org
Subject: Re: Need urgent help

 

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

 

But when I do

fs =96ls /user/ipg_intg_user/AP/scripts/lib/ , I am = able to see the JAR file.

 

Please help.

 

Thanks,

Shouvanik

 


This message is for the designated recipient only and may contain privilege= d, proprietary, or otherwise confidential information. If you have received= it in error, please notify the sender immediately and delete the original.= Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications w= ith Accenture and its affiliates, including e-mail and instant messaging (i= ncluding content), may be scanned by our systems for the purposes of inform= ation security and assessment of internal compliance with Accenture policy.
___________________________________________________________________________= ___________

www.accenture.com



 

--

Andr=E9 Ara=FAjo
Big Data Consultant/Solutions Architect
The Pythian Group - Australia - www.pythian.com

Office (calls from within Australia): 1300 366 021 x1270
Office (international): +61 2 8016 7000  x270 OR +1 613 565 8696   x1270
Mobile: +61 410 323 559
Fax: +61 2 9805 0544
IM: pythianaraujo @ AIM/MSN/Y! or araujo@pythian.com @ GTalk

 

=93Success is not abou= t standing at the top, it's the steps you leave behind<= /b>.=94 =97 Iker Pou (rock climber)

 

--

 




--
Andr=E9 Ara=FAjo
Big Data Consultant/Solutions Architect
The Pythian Group - Australia - www.pythian.com

Office (calls from within Australia): 1300 366 021 x1270
Office (international): +61 2 8016 7000  x270 OR +1 613 565 8696   x1270
Mobile: +61 410 323 559
Fax: +61 2 9805 0544
IM: pythianaraujo @ AIM/MSN/Y! or araujo@pythian.com @ GTalk

=93Success is not about standing at the top, it's the steps you leave behind.=94 =97 = Iker Pou (rock climber)

--






--
Andr=E9 Ara=FAjo
Big Data Consultant/Solutions Architect
The Pythian Group - Australia - www.pythian.com

Office (calls from within Australia): 1300 366 021 x1270
Office (international): +61 2 8016 7000  x270 OR +1 613= 565 8696   x1270
Mobile: +61 410 323 559
Fax: +61 2 9805 0544
IM: pythianaraujo @ AIM/MSN/Y! or araujo@pythian.com @ GTalk

=93Success is not about standing at the top, it's the steps you leave behind.=94 =97 = Iker Pou (rock climber)

--



--_000_x4gxeus3b6nxh0hlll9ewfg91404285117846emailandroidcom_--