Hi, From an Hadoop cluster I can request my index using curl, like this : curl -u user:pwd -X GET http://mynode:9020/myindex, it works, but when I try to request using Hive (Beeline) I have the famous exception "Cannot detect ES version". My external table has been created using ES handler like t…

Curl works but Hive can't connect to ES

A_Felgueiras (A Felgueiras) June 24, 2019, 1:51am 2

Adding monitor role to Elastic user we use on Hive and permission on slash resolved this error. It seems at the end that the user has to have this role at least to detect ES version.

Topic		Replies	Views
Hive - Elasticsearch: Cannot detect ES version Elasticsearch es-hadoop	1	1477	May 25, 2017
ES-hive integration error- 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' Elasticsearch es-hadoop	1	1004	June 13, 2019
Elasticsearch hive query Elasticsearch es-hadoop	2	836	August 14, 2017
Cannot detect ES version Elasticsearch es-hadoop	2	2149	December 30, 2016
Cannot detect ES version - typically this happens if the network/Elasticsearch cluster is not accessible (HIVE) es.nodes.wan.only Elasticsearch es-hadoop	2	2692	September 11, 2019

Curl works but Hive can't connect to ES

Related topics