Has anyone integrated hive with AWS ElasticSearch service

[devps]

We are implementing hive 3.4 ( latest version) with AWS ElasticSearch 6.7.
After creating the AWS ELK service we got and end point and while redirecting that endpoint we are getting result below:

{
"name" : "7wcfm5H",
"cluster_name" : "954753222468:sec",
"cluster_uuid" : "zvWGA-6-R163KXcigmlSow",
"version" : {
"number" : "6.7.0",
"build_flavor" : "oss",
"build_type" : "zip",
"build_hash" : "8453f77",
"build_date" : "2019-08-21T18:49:19.475514Z",
"build_snapshot" : false,
"lucene_version" : "7.7.0",
"minimum_wire_compatibility_version" : "5.6.0",
"minimum_index_compatibility_version" : "5.0.0"
},
"tagline" : "You Know, for Search"
}

When I am trying to connect with hive , getting "Elasticsearch cluster is unreachable"

I think, I am not able to connect with elastic database.

Can someone please suggest me what I am missing here? thanks

[ArnaudLhutereau]

Hi,
I don't think it's possible due to the transport protocol :
https://github.com/TheHive-Project/TheHiveDocs/blob/master/FAQ.md#can-i-connect-thehive-to-an-aws-elasticsearch-service

[devps]

Thank you 🙏

[saadkadhi]

@devps, the FAQ @ArnaudLhutereau pointed to is outdated and we haven't gotten around to update it yet. Sorry for that.

TheHive 3.4.0 supports ES6 as does Cortex 3.0.0. While we have not tested them on AWS, they should be able to work given they support the HTTP transport protocol. @arnydo may be able to help here as he asked a related question on Twitter a few days ago.

Please let us know if it works and what you have done to get it working so we can update the FAQ accordingly.

[kesh-stripe]

This is an old topic, but we were able to get this to work, some details can be found in this blog post: https://robertheaton.com/2020/01/14/how-to-set-up-the-hive-on-aws-elasticsearch/