Yes, it is a workaround not a fix. ________________________________ From: Igor Kravzov <igork.ine...@gmail.com> Sent: Wednesday, July 6, 2016 3:02:44 PM To: user@hive.apache.org Subject: Re: hive.aux.jars.path question
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<mailto:fan...@dataguise.com>> wrote: Yes, we need to restart hiveserver in Ambari ________________________________ From: Igor Kravzov <igork.ine...@gmail.com<mailto:igork.ine...@gmail.com>> Sent: Wednesday, July 6, 2016 2:36:41 PM To: user@hive.apache.org<mailto: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<mailto: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<mailto:igork.ine...@gmail.com>> Sent: Wednesday, July 6, 2016 2:13:07 PM To: user@hive.apache.org<mailto: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.
