# Elastic search exclude few fields while reading

**URL:** https://discuss.elastic.co/t/elastic-search-exclude-few-fields-while-reading/274065
**Category:** Elasticsearch
**Tags:** es-hadoop
**Created:** [May 26, 2021, 1:36pm UTC](https://discuss.elastic.co/t/elastic-search-exclude-few-fields-while-reading/274065 "2021-05-26T13:36:25Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![whiletruelearn](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/whiletruelearn/32/43331_2.png) [@whiletruelearn](https://discuss.elastic.co/u/whiletruelearn)
#### Post date: [May 26, 2021, 1:36pm UTC](https://discuss.elastic.co/t/elastic-search-exclude-few-fields-while-reading/274065/1 "2021-05-26T13:36:25Z")

</div>

Hi,

I am using `elasticsearch spark connector` and trying to use `es.read.field.exclude` to exclude reading two fields. In the documentation there is this example [given](https://www.elastic.co/guide/en/elasticsearch/hadoop/current/configuration.html)

```auto
es.read.field.exclude = company.income

```

I have two fields `host.ip` and `host.mac` which i am trying to exclude. How do i use this configuration when there are more than 1 field?

---

<div class="post-metadata">

### Author: ![Gokul6](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gokul6/32/84049_2.png) [@Gokul6](https://discuss.elastic.co/u/Gokul6)
#### Post date: [May 26, 2021, 1:54pm UTC](https://discuss.elastic.co/t/elastic-search-exclude-few-fields-while-reading/274065/2 "2021-05-26T13:54:46Z")

</div>

try like this ("es.read.field.exclude","host.ip,host.mac")

---

<div class="post-metadata">

### Author: ![Gokul6](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gokul6/32/84049_2.png) [@Gokul6](https://discuss.elastic.co/u/Gokul6)
#### Post date: [May 26, 2021, 1:56pm UTC](https://discuss.elastic.co/t/elastic-search-exclude-few-fields-while-reading/274065/3 "2021-05-26T13:56:11Z")

</div>

val conf = new SparkConf().setAppName("elastic").setMaster("local[\*]")  
.set("es.read.field.exclude","host.ip,host.mac")

---

<div class="post-metadata">

### Author: ![whiletruelearn](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/whiletruelearn/32/43331_2.png) [@whiletruelearn](https://discuss.elastic.co/u/whiletruelearn)
#### Post date: [May 26, 2021, 2:11pm UTC](https://discuss.elastic.co/t/elastic-search-exclude-few-fields-while-reading/274065/5 "2021-05-26T14:11:55Z")

</div>

Thanks @Gokul6 . That works.

---

<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: [June 23, 2021, 2:12pm UTC](https://discuss.elastic.co/t/elastic-search-exclude-few-fields-while-reading/274065/6 "2021-06-23T14:12:53Z")

</div>

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