# Put output in a sub field from JDBC input

**URL:** <https://discuss.elastic.co/t/put-output-in-a-sub-field-from-jdbc-input/59460>\
**Category:** Logstash\
**Created:** [August 31, 2016, 7:27pm UTC](https://discuss.elastic.co/t/put-output-in-a-sub-field-from-jdbc-input/59460 "2016-08-31T19:27:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ave19](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ave19/32/11631_2.png) [@ave19](https://discuss.elastic.co/u/ave19)\
**Post date:** [August 31, 2016, 7:27pm UTC](https://discuss.elastic.co/t/put-output-in-a-sub-field-from-jdbc-input/59460/1 "2016-08-31T19:27:26Z")

</div>

This is just a feature request sort of thing.

I would like to put all the data I pull from the JDBC input inside a subfield with a configurable name.

Something like:

input.conf

```auto
input {
   jdbc {
      ...
      jdbc_output_field => "my_data"
    }
}

```

So that the output looks like:

```auto
{
     "_index": "my_index-2016.08.31",
     "_type": "foo",
     "_id": "abc123",
     "_score": 1,
     "_source": { 
        "my_data": {
              "field_one_from_db": 1,
              "field_two_from_db": 2
        },
       "some_field_i_add": "foo",
       "structure": {
          "more_things": "bar"
       }
     }
}

```

What do you think?

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [August 31, 2016, 8:13pm UTC](https://discuss.elastic.co/t/put-output-in-a-sub-field-from-jdbc-input/59460/2 "2016-08-31T20:13:56Z")

</div>

Doesn't sound unreasonable and it looks like it would be a trivial change. Feel free to file a feature request: [https://github.com/logstash-plugins/logstash-input-jdbc/issues/new](https://github.com/logstash-plugins/logstash-input-jdbc/issues/new)

---

<div class="post-metadata">

**Author:** ![ave19](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ave19/32/11631_2.png) [@ave19](https://discuss.elastic.co/u/ave19)\
**Post date:** [September 1, 2016, 2:12pm UTC](https://discuss.elastic.co/t/put-output-in-a-sub-field-from-jdbc-input/59460/3 "2016-09-01T14:12:02Z")

</div>

Thanks!

---

<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:** [July 6, 2017, 4:40am UTC](https://discuss.elastic.co/t/put-output-in-a-sub-field-from-jdbc-input/59460/4 "2017-07-06T04:40:25Z")

</div>