ElasticSearch and Hive

Elastic Stack Elasticsearch
1

I can create hive elasticsearch table:
CREATE EXTERNAL TABLE artists_es ( id BIGINT, name STRING )
STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler'
TBLPROPERTIES('es.nodes'='10.0.14.71','es.port'= '9200','es.resource'= 'radio/artists');

But I can't select or insert data into this table
here is the error:
Failed with exception java.io.IOException:org.elasticsearch.hadoop.EsHadoopIllegalArgumentException: Unsupported/Unknown Elasticsearch version 5.6.0

Can anyone advise?

2

It's because you are using an incompatible version of es-hadoop (probably version 2.2.x).

According to this you should be using es-hadoop at least in version 5.x to be able to connect with Elasticsearch version 5.6.0

3

It is best to use ES-Hadoop 5.6.0 and up for interacting with 5.6, as it is specifically tested against Elasticsearch 5.6.0+.

4

The issue is resolved.

5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.