Created on 10-23-2020 11:57 AM - edited 10-23-2020 12:09 PM
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?