I have created one node ES cluster and want to integrate with my hadoop cluster, we are using ES 6.6 and HDP 3 version. we want to integrate ES with hive and followed the given documents.
But when try to create an external table after connecting to hive on same node where ES cluster is running it says "Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. 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=08S01,code=1)"
Command which I ran is CREATE EXTERNAL TABLE elastic_table(name string, ID int, profession string) STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler' TBLPROPERTIES('es.resource' = 'customer','es.nodes.wan.only' = 'true','es.index.auto.create'='TRUE');
I suspect this is due to our hadoop cluster is kerberised, could you please guide us to make ES cluster accessible to our hadoop cluster.
Looking for response.
Thanks a lot,