Hive-Elasticsearch connectivity, RESOLVED

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', ''='true', 'es.nodes'='<elastic_IP>', 'es.port'='9200');

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

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

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