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

Cannot detect ES Version

New Contributor

Hi,

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: java.io.IOException: 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.resource'='test_index',
'es.index.read.missing.as.empty'='true',
'es.mapping.date.rich'='false',
'es.nodes.discovery' = 'true',
'es.nodes.resolve.hostname' = 'false',
'es.query'='?q=*');

 

 

Hive Aux Jars have already been inserted:

 

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

 

I have also inserted the elasticsearch-hadoop-hive-7.9.3.jar in:
/opt/cloudera/parcels/CDH/lib/hive/lib/.

 


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?