Hello,
We are using Cloudera CDH5.12 and elasticsearch-hadoop-6.2.1 . We added the ES-hadoop jars path to Cloudera Manager->Clusters->Hive->Advanced and set the value of: Hive Auxiliary JARs Directory to the jar directory. Now if we keep all the 21 jars for different tools like mr, hive, pig, spark etc. in the directory we get the below error.
Diagnostic Messages for this Task:
Error: java.lang.RuntimeException: java.lang.Error: Multiple ES-Hadoop versions detected in the classpath; please use only one
jar:file:/yarn/nm/usercache/hive/filecache/1747/elasticsearch-spark-20_2.11-6.2.1.jar
jar:file:/yarn/nm/usercache/hive/filecache/1751/elasticsearch-hadoop-mr-6.2.1.jar
jar:file:/yarn/nm/usercache/hive/filecache/1755/elasticsearch-hadoop-cascading-6.2.1.jar
jar:file:/yarn/nm/usercache/hive/filecache/1738/elasticsearch-hadoop-6.2.1.jar
jar:file:/yarn/nm/usercache/hive/filecache/1743/elasticsearch-hadoop-pig-6.2.1.jar
jar:file:/yarn/nm/usercache/hive/filecache/1739/elasticsearch-hadoop-hive-6.2.1.jar
jar:file:/yarn/nm/usercache/hive/filecache/1760/elasticsearch-storm-6.2.1.jar
at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:179)
at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54)
at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:459)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:415)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1917)
at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
But if we remove all the other jars and only keep one jar as was suggested in other posts then we get the opposite error. This seems like a catch-22 situation where we can neither remove nor keep all the other jars. Why cant the code just ignore the jars not needed if its the same version?
2018-02-21 17:11:55,641 INFO org.apache.hadoop.hive.ql.exec.TableScanOperator: [HiveServer2-Handler-Pool: Thread-727]: Initialization Done 393 TS
2018-02-21 17:12:18,366 ERROR org.apache.hadoop.hive.common.FileUtils: [HiveServer2-Handler-Pool: Thread-728]: The jar file path file:///opt/elastichadoop/elasticsearch-hadoop-6.2.1/dist/elasticsearc
h-hadoop-cascading-6.2.1.jar doesn't exist
2018-02-21 17:12:18,366 ERROR org.apache.hadoop.hive.common.FileUtils: [HiveServer2-Handler-Pool: Thread-728]: The jar file path file:///opt/elastichadoop/elasticsearch-hadoop-6.2.1/dist/elasticsearc
h-hadoop-cascading-6.2.1-javadoc.jar doesn't exist
2018-02-21 17:12:18,366 ERROR org.apache.hadoop.hive.common.FileUtils: [HiveServer2-Handler-Pool: Thread-728]: The jar file path file:///opt/elastichadoop/elasticsearch-hadoop-6.2.1/dist/elasticsearc
h-hadoop-cascading-6.2.1-sources.jar doesn't exist
2018-02-21 17:12:18,366 ERROR org.apache.hadoop.hive.common.FileUtils: [HiveServer2-Handler-Pool: Thread-728]: The jar file path file:///opt/elastichadoop/elasticsearch-hadoop-6.2.1/dist/elasticsearc
h-hadoop-mr-6.2.1.jar doesn't exist
2018-02-21 17:12:18,366 ERROR org.apache.hadoop.hive.common.FileUtils: [HiveServer2-Handler-Pool: Thread-728]: The jar file path file:///opt/elastichadoop/elasticsearch-hadoop-6.2.1/dist/elasticsearc
h-hadoop-mr-6.2.1-javadoc.jar doesn't exist
2018-02-21 17:12:18,366 ERROR org.apache.hadoop.hive.common.FileUtils: [HiveServer2-Handler-Pool: Thread-728]: The jar file path file:///opt/elastichadoop/elasticsearch-hadoop-6.2.1/dist/elasticsearc
h-hadoop-mr-6.2.1-sources.jar doesn't exist
2018-02-21 17:12:18,366 ERROR org.apache.hadoop.hive.common.FileUtils: [HiveServer2-Handler-Pool: Thread-728]: The jar file path file:///opt/elastichadoop/elasticsearch-hadoop-6.2.1/dist/elasticsearc
h-hadoop-pig-6.2.1.jar doesn't exist
2018-02-21 17:12:18,366 ERROR org.apache.hadoop.hive.common.FileUtils: [HiveServer2-Handler-Pool: Thread-728]: The jar file path file:///opt/elastichadoop/elasticsearch-hadoop-6.2.1/dist/elasticsearc
h-hadoop-pig-6.2.1-javadoc.jar doesn't exist
2018-02-21 17:12:18,367 ERROR org.apache.hadoop.hive.common.FileUtils: [HiveServer2-Handler-Pool: Thread-728]: The jar file path file:///opt/elastichadoop/elasticsearch-hadoop-6.2.1/dist/elasticsearch-hadoop-pig-6.2.1-sources.jar doesn't exist
2018-02-21 17:12:18,367 ERROR org.apache.hadoop.hive.common.FileUtils: [HiveServer2-Handler-Pool: Thread-728]: The jar file path file:///opt/elastichadoop/elasticsearch-hadoop-6.2.1/dist/elasticsearch-spark-20_2.11-6.2.1.jar doesn't exist
2018-02-21 17:12:18,367 ERROR org.apache.hadoop.hive.common.FileUtils: [HiveServer2-Handler-Pool: Thread-728]: The jar file path file:///opt/elastichadoop/elasticsearch-hadoop-6.2.1/dist/elasticsearch-spark-20_2.11-6.2.1-javadoc.jar doesn't exist
2018-02-21 17:12:18,367 ERROR org.apache.hadoop.hive.common.FileUtils: [HiveServer2-Handler-Pool: Thread-728]: The jar file path file:///opt/elastichadoop/elasticsearch-hadoop-6.2.1/dist/elasticsearch-spark-20_2.11-6.2.1-sources.jar doesn't exist
2018-02-21 17:12:18,367 ERROR org.apache.hadoop.hive.common.FileUtils: [HiveServer2-Handler-Pool: Thread-728]: The jar file path file:///opt/elastichadoop/elasticsearch-hadoop-6.2.1/dist/elasticsearch-storm-6.2.1.jar doesn't exist
2018-02-21 17:12:18,367 ERROR org.apache.hadoop.hive.common.FileUtils: [HiveServer2-Handler-Pool: Thread-728]: The jar file path file:///opt/elastichadoop/elasticsearch-hadoop-6.2.1/dist/elasticsearch-storm-6.2.1-javadoc.jar doesn't exist
2018-02-21 17:12:18,367 ERROR org.apache.hadoop.hive.common.FileUtils: [HiveServer2-Handler-Pool: Thread-728]: The jar file path file:///opt/elastichadoop/elasticsearch-hadoop-6.2.1/dist/elasticsearch-storm-6.2.1-sources.jar doesn't exist
2018-02-21 17:12:18,368 WARN org.apache.hadoop.hive.conf.HiveConf: [HiveServer2-Handler-Pool: Thread-728]: HiveConf of name hive.server2.idle.session.timeout_check_operation does not exist