Connect Hive to Elasticsearch 6.2.3

Elastic Stack Elasticsearch
1

HI,

I use Hortonworks and I created a single-node cluster, I installed elasticsearch and kibana (6.2.3).
I downloaded the jar file elasticsearch-hadoop-6.2.3.jar and added it in hive-site.xml file with the property name hive.aux.jars.path.

I have database named hosix.

I created an external table like this :
CREATE EXTERNAL TABLE test (...)
STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler'
TBLPROPERTIES('es.resource' = 'hosix/test');

But when I want to select or loaded this table (select or insert queries) It shows me the following error :

Capture
Capture.JPG831×72 9.65 KB

2

moved this into the hadoop forum

3

We've seen some issues in the past with specifying jars using the hive aux jars path. Have you tried using the ADD JAR directive in the hive script to see if that works?

4

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