# Hive overwhelming Elasticsearch

**URL:** <https://discuss.elastic.co/t/hive-overwhelming-elasticsearch/269930>\
**Category:** Elasticsearch\
**Tags:** es-hadoop\
**Created:** [April 12, 2021, 6:11pm UTC](https://discuss.elastic.co/t/hive-overwhelming-elasticsearch/269930 "2021-04-12T18:11:43Z")\
**Posts on this page:** 1\
**Showing post:** 15

<div class="post-metadata">

**Author:** ![albertkohl](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@albertkohl](https://discuss.elastic.co/u/albertkohl)\
**Post date:** [April 14, 2021, 2:10am UTC](https://discuss.elastic.co/t/hive-overwhelming-elasticsearch/269930/15 "2021-04-14T02:10:19Z")

</div>

```auto
ip heap.percent ram.percent cpu load_1m load_5m load_15m node.role master name
192.168.4.63 75 33 0 0.20 0.05 0.02 cdfhilrstw - es-d01
192.168.4.60 56 39 1 0.00 0.05 0.01 ilmr - es-m01
192.168.4.64 36 33 0 0.02 0.03 0.00 cdfhilrstw - es-d02
192.168.4.62 61 28 0 0.00 0.00 0.00 ilmr - es-m03
192.168.4.61 20 29 0 0.00 0.00 0.01 ilmr * es-m02

```

but when i do the insert, i usually drop one of the data nodes.

odd thing is, if i do just one shard, it works fine, it's only when i do more than one.

---

_[View the full topic](https://discuss.elastic.co/t/hive-overwhelming-elasticsearch/269930)._