Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Cannot detect ES Version

Highlighted

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?

Don't have an account?
Coming from Hortonworks? Activate your account here