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.