Logstash jdbc input for multi fields and nested objects

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?

1 Like

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.

1 Like