Hi, have you add the property in hive( hive.aux.jars.path. The location of the plugin jars that contain implementations of user defined functions and serdes.)
https://cwiki.apache.org/confluence/display/Hive/AdminManual+Configuration Thanks, Abirami On Tue, Jul 1, 2014 at 9:56 PM, hadoop hive <hadooph...@gmail.com> wrote: > Are you able to see the file after giving full path like > > Hadoop fs -ls hdfs://$lpath:9000/pathToJar > On Jul 2, 2014 10:17 AM, <shouvanik.hal...@accenture.com> wrote: > >> 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 9:37 AM, <shouvanik.hal...@accenture.com> 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_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/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 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 >> >> On Jul 2, 2014 9:21 AM, <shouvanik.hal...@accenture.com> wrote: >> >> >> >> But when I do >> >> fs –ls /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 >> privileged, 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 with Accenture and its affiliates, >> including e-mail and instant messaging (including content), may be scanned >> by our systems for the purposes of information security and assessment of >> internal compliance with Accenture policy. >> >> ______________________________________________________________________________________ >> >> www.accenture.com >> >