# Hive elasticsearch integration

**URL:** <https://discuss.elastic.co/t/hive-elasticsearch-integration/95365>\
**Category:** Elasticsearch\
**Tags:** es-hadoop\
**Created:** [August 1, 2017, 2:50pm UTC](https://discuss.elastic.co/t/hive-elasticsearch-integration/95365 "2017-08-01T14:50:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![aliyesami](https://avatars.discourse-cdn.com/v4/letter/a/ecb155/32.png) [@aliyesami](https://discuss.elastic.co/u/aliyesami)\
**Post date:** [August 1, 2017, 2:50pm UTC](https://discuss.elastic.co/t/hive-elasticsearch-integration/95365/1 "2017-08-01T14:50:21Z")

</div>

I am sure there are many people who are using this but I am not getting any response to my issue.  
please can someone guide me on my issue ? If I create a hive ES table on node 1 its creating es-index on node4 or node5 randomly .  
Also I can't query the table in hive as it cant find the index on node1.  
I also was unable to make elasticsearch work on single node, if I turn elasticsearch service on node2,3,4,5 then the hive table creation fails .

There must be some setting in elasticsearch.yml that I need to set to be able to create index on node1 .

appreciate anyone helping me on this.

> [root@hadoop1 elasticsearch]# more elasticsearch.yml  
> cluster.name: ftes  
> node.name: "hadoop1"  
> path.data: /elastic/data  
> path.logs: /elastic/logs

---

<div class="post-metadata">

**Author:** ![james.baiera](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/james.baiera/32/10209_2.png) [@james.baiera](https://discuss.elastic.co/u/james.baiera)\
**Post date:** [August 1, 2017, 9:31pm UTC](https://discuss.elastic.co/t/hive-elasticsearch-integration/95365/2 "2017-08-01T21:31:15Z")

</div>

@aliyesami Please do not open multiple topics for the same issue on the forum. Keep in mind that community members spend their own time on the forums to help people. If you are having trouble with the connector it will eventually be addressed. Thank you.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 29, 2017, 9:31pm UTC](https://discuss.elastic.co/t/hive-elasticsearch-integration/95365/3 "2017-08-29T21:31:44Z")

</div>

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