# Logstash jdbc input for multi fields and nested objects

**URL:** https://discuss.elastic.co/t/logstash-jdbc-input-for-multi-fields-and-nested-objects/27020
**Category:** Logstash
**Created:** [August 7, 2015, 2:49am UTC](https://discuss.elastic.co/t/logstash-jdbc-input-for-multi-fields-and-nested-objects/27020 "2015-08-07T02:49:02Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![vijay116](https://avatars.discourse-cdn.com/v4/letter/v/50afbb/32.png) [@vijay116](https://discuss.elastic.co/u/vijay116)
#### Post date: [August 7, 2015, 2:49am UTC](https://discuss.elastic.co/t/logstash-jdbc-input-for-multi-fields-and-nested-objects/27020/1 "2015-08-07T02:49:02Z")

</div>

Does the plugin support both cases? I had issue with both.

For examples with the mapping

`
{
"consumer": {
  "properties": {
  	"name": { 
	  "type": "string",
	  "fields": {
		"raw": { 
		  "type": "string",
		  "index": "not_analyzed"
		}
	  }
    },
	"homeAddress": {
      "properties": {
        "location" : {"type": "geo_point"}
      }
    }
  }
}
}
`

and select query as  
`
select name, homeLocation as "homeAddress.location" from consumer;
`  
The raw field is not generated automatically and also the complex/nested object are not as per the mapping i.e a new field is generated with homeAddress.location as string instead of geopoint.

Any pointers?

---

<div class="post-metadata">

### Author: ![ghayes](https://avatars.discourse-cdn.com/v4/letter/g/45deac/32.png) [@ghayes](https://discuss.elastic.co/u/ghayes)
#### Post date: [August 14, 2015, 8:04pm UTC](https://discuss.elastic.co/t/logstash-jdbc-input-for-multi-fields-and-nested-objects/27020/2 "2015-08-14T20:04:24Z")

</div>

Yes, I'm looking for a similar result. Looking at other jdbc input plugins and tools that have been created I have seen notation such as customer.address to create nested documents or customer[condition] to create arrays. I really hope this Logstash plugin adds these features soon.

---

<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, 5:31am UTC](https://discuss.elastic.co/t/logstash-jdbc-input-for-multi-fields-and-nested-objects/27020/3 "2017-07-06T05:31:55Z")

</div>