Yes, we need to restart hiveserver in Ambari ________________________________ From: Igor Kravzov <[email protected]> Sent: Wednesday, July 6, 2016 2:36:41 PM To: [email protected] 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 <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> Sent: Wednesday, July 6, 2016 2:13:07 PM To: [email protected]<mailto:[email protected]> 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.
