# Logstash Additional fields added by ES output

**URL:** https://discuss.elastic.co/t/logstash-additional-fields-added-by-es-output/157232
**Category:** Elasticsearch
**Created:** [November 18, 2018, 3:49pm UTC](https://discuss.elastic.co/t/logstash-additional-fields-added-by-es-output/157232 "2018-11-18T15:49:11Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Divit\_Sharma](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/divit_sharma/32/32348_2.png) [@Divit\_Sharma](https://discuss.elastic.co/u/Divit_Sharma)
#### Post date: [November 18, 2018, 3:49pm UTC](https://discuss.elastic.co/t/logstash-additional-fields-added-by-es-output/157232/1 "2018-11-18T15:49:11Z")

</div>

I am using logstash. input is jdbc and output is es.

Just wanted to know the fields which I see when using just stout in output are the same fields which will be index to es or es output plug in might add some other extra fields? I have to debug some issue .

---

<div class="post-metadata">

### Author: ![Divit\_Sharma](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/divit_sharma/32/32348_2.png) [@Divit\_Sharma](https://discuss.elastic.co/u/Divit_Sharma)
#### Post date: [November 18, 2018, 3:52pm UTC](https://discuss.elastic.co/t/logstash-additional-fields-added-by-es-output/157232/2 "2018-11-18T15:52:47Z")

</div>

![20181117_213856](https://us1.discourse-cdn.com/elastic/original/3X/e/0/e024dd62174b33e62d4d6394ce3bf2f90331b1da.jpeg)

When input =jdbc hive, output =csv. Code works.

When input =jdbc hive, output =es. Code fails.

When input =jdbc oracle, output =es. Code works.

When input =csv , output =es. Code works.

So it's crazy. Not able to fix this for two days now.

---

<div class="post-metadata">

### Author: ![Divit\_Sharma](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/divit_sharma/32/32348_2.png) [@Divit\_Sharma](https://discuss.elastic.co/u/Divit_Sharma)
#### Post date: [November 18, 2018, 3:55pm UTC](https://discuss.elastic.co/t/logstash-additional-fields-added-by-es-output/157232/3 "2018-11-18T15:55:05Z")

</div>

![20181117_212516](https://us1.discourse-cdn.com/elastic/original/3X/0/4/04f822604a1243a07048f2d374eb80342d0f278a.jpeg) ![20181117_212132](https://us1.discourse-cdn.com/elastic/original/3X/b/8/b8618a3a134689bf257b328f93b6e85ca250c30c.jpeg)

Error

---

<div class="post-metadata">

### Author: ![aravindputrevu](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aravindputrevu/32/24816_2.png) [@aravindputrevu](https://discuss.elastic.co/u/aravindputrevu)
#### Post date: [November 19, 2018, 10:04am UTC](https://discuss.elastic.co/t/logstash-additional-fields-added-by-es-output/157232/4 "2018-11-19T10:04:49Z")

</div>

Please use text wrapped under \</\> than images from next time.

I suppose you are trying to connect Apache Hive to Elasticsearch.

If so, kindly use ES-Hadoop. Here is the [link](https://www.elastic.co/guide/en/elasticsearch/hadoop/current/hive.html)

---

<div class="post-metadata">

### Author: ![Divit\_Sharma](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/divit_sharma/32/32348_2.png) [@Divit\_Sharma](https://discuss.elastic.co/u/Divit_Sharma)
#### Post date: [November 19, 2018, 12:41pm UTC](https://discuss.elastic.co/t/logstash-additional-fields-added-by-es-output/157232/5 "2018-11-19T12:41:18Z")

</div>

Why not improve jdbc plug in? I can bring data from Hive to file. Just that es output is not able create some autogenerated fields I guess.

---

<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: [December 17, 2018, 12:41pm UTC](https://discuss.elastic.co/t/logstash-additional-fields-added-by-es-output/157232/6 "2018-12-17T12:41:23Z")

</div>

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