Support Questions
Find answers, ask questions, and share your expertise

Cannot detect ES Version

New Contributor


I am creating a Cloudera CDH 6.1.2 Hive connection with Elasticsearch 7.9.3.


I am getting below error while selecting the data from the table.


Error: org.elasticsearch.hadoop.EsHadoopIllegalArgumentException: Cannot detect ES version - typically this happens if the network/Elasticsearch cluster is not accessible or when targeting a WAN/Cloud instance without the proper setting 'es.nodes.wan.only' (state=,code=0)


Hive Create Table contains following configuration:



'es.nodes'='http://<elasticsearch service in openshift URL>',
'es.port' = '',
'es.nodes.discovery' = 'true',
'es.nodes.resolve.hostname' = 'false',



Hive Aux Jars have already been inserted:


Configuration Location: HiveServer2 Advanced Configuration Snippet (Safety Valve) for hive-site.xml
Property Value: /opt/local/hive/es/es.jar


I have also inserted the elasticsearch-hadoop-hive-7.9.3.jar in:


curl http://<elasticsearch service in openshift URL>



"name" : "es-cluster-1",
"cluster_name" : "infra-efk",
"cluster_uuid" : "gc6Fage-QH-3X6AFhEJzwg",
"version" : {
"number" : "7.9.3",
"build_flavor" : "default",
"build_type" : "docker",
"build_hash" : "c4138e51121ef06a6404866cddc601906fe5c868",
"build_date" : "2020-10-16T10:36:16.141335Z",
"build_snapshot" : false,
"lucene_version" : "8.6.2",
"minimum_wire_compatibility_version" : "6.8.0",
"minimum_index_compatibility_version" : "6.0.0-beta1"
"tagline" : "You Know, for Search"


Can someone help on this?