Hive-Elasticsearch connectivity, RESOLVED


(Kishore Hulikere Sampathkumar) #1

Hello all,

I am trying to create a external table from hive. The table will be created in Elasticsearch, but it is giving me connection refused error.

Hive - Present in Cloudera Quickstart VM
Elasticsearch and Kibana - Present in Ubuntu Server VM

The Command used:
$ create external table abc(.....)
stored by 'org.elasticsearch.hadoop.hive.EsStorageHandler'
tblproperties ( 'es.resource'='abc', 'es.index.auto.create'='true', 'es.nodes'='<elastic_IP>', 'es.port'='9200');

Error:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: java.net.ConnectException Call From quickstart.cloudera/10.0.2.15 to quickstart.cloudera:8020 failed on connection exception: java.net.ConnectException: Connection refused; For more details see: http://wiki.apache.org/hadoop/ConnectionRefused)

Please provide any leads on how to overcome this problem.
Thanks in advance.


(system) #2

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