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.