It worked. Thanks. Still not sure if it is right way to do it. On Wed, Jul 6, 2016 at 5:45 PM, Fan Xu <fan...@dataguise.com> wrote:
> Yes, we need to restart hiveserver in Ambari > ------------------------------ > *From:* Igor Kravzov <igork.ine...@gmail.com> > *Sent:* Wednesday, July 6, 2016 2:36:41 PM > *To:* user@hive.apache.org > *Subject:* Re: hive.aux.jars.path question > > Just copied. Didn't help. Do I need to restart nodes? > > On Wed, Jul 6, 2016 at 5:20 PM, Fan Xu <fan...@dataguise.com> wrote: > >> Got similar issues. >> >> I have tried to point hive.aux.jars.path to a local/hdfs locations, >> none of them works. >> >> I could not find a way to make hive.aux.jars.path work, would it be a >> bug? >> >> The only way I made it work is to add my jar to {hive_home}/lib/ >> >> >> Thanks, >> >> >> Fan >> >> ------------------------------ >> *From:* Igor Kravzov <igork.ine...@gmail.com> >> *Sent:* Wednesday, July 6, 2016 2:13:07 PM >> *To:* user@hive.apache.org >> *Subject:* hive.aux.jars.path question >> >> Hi guys, >> >> HDP 2.4.2 distribution >> >> I want to add elasticsearch-hadoop-2.3.2.jar connector to hive path >> using hive.aux.jars.path property. Added it to custom hive-site.xml >> >> Copied jar to /user/hive/aux_jars folder in HDFS. I specified path for >> the property as /user/hive/aux_jars/elasticsearch-hadoop-2.3.2.jar >> >> But when I try to create table I get the following error >> >> org.apache.ambari.view.hive.client.HiveInvalidQueryException: Error while >> compiling statement: FAILED: SemanticException Cannot find class >> 'org.elasticsearch.hadoop.hive.EsStorageHandler' [ERROR_STATUS] >> >> >> What is the right way to specify the pat and where should I place the JAR? >> >> Thanks in advance. >> > >