# Logstash jdbc plugin input for mutliple table joins of one to many relationships
**URL:** https://discuss.elastic.co/t/logstash-jdbc-plugin-input-for-mutliple-table-joins-of-one-to-many-relationships/59933
**Category:** Logstash
**Created:** [September 7, 2016, 12:50am UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-input-for-mutliple-table-joins-of-one-to-many-relationships/59933 "2016-09-07T00:50:44Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Syed\_Ather](https://discuss.elastic.co/u/Syed_Ather)
#### Post date: [September 7, 2016, 12:50am UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-input-for-mutliple-table-joins-of-one-to-many-relationships/59933/1 "2016-09-07T00:50:44Z")
HI All,
I have two tables linked in a one to many relationship , i.e for each row in first table there will be multiple rows in second table .
One employee can have many orders assigned to them .
ex :
* * *
how can i achieve the data upload to elastic for a single index to have all orders in the form of an array of orders inside the main JSON object?
like..
* * *
I also want to add that i have read about custom mappings and templates for elastic , but i need the logstash way of pushing data in the format i have shown .
Thanks !
---
### Author:  [@Syed\_Ather](https://discuss.elastic.co/u/Syed_Ather)
#### Post date: [September 7, 2016, 5:04pm UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-input-for-mutliple-table-joins-of-one-to-many-relationships/59933/2 "2016-09-07T17:04:48Z")
@magnusbaeck Can you please offer some assistance on this ?
---
### Author:  [@sureshadapa](https://discuss.elastic.co/u/sureshadapa)
#### Post date: [September 9, 2016, 1:59pm UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-input-for-mutliple-table-joins-of-one-to-many-relationships/59933/3 "2016-09-09T13:59:52Z")
############## Nested Objects ###
PUT employee\_orders
{
"mappings": {
"employee": {
"properties": {
"\_id": { "type": "long" },
"name": { "type": "string" },
"orders": { "type": "nested",
"properties": {
"orderid": { "type": "string" },
"description": { "type": "string" }
}
}
}
}
}
}
GET employee\_orders
POST employee\_orders/employee/1
{
"name": "Suresh"
}
PUT employee\_orders/employee/2
{
"name": "Sudha"
}
GET employee\_orders/employee/1
GET employee\_orders/employee/2
DELETE employee\_orders/employee/1
GET employee\_orders/\_search
POST employee\_orders/employee/1/\_update
{
"doc":{
"orders":{
"orderid": "0001",
"description": "Leather Jacket"
}
}
}
########Dynamic Mapping #######
GET emporders/\_search
PUT /emporders
{
"mappings": {
"empid": {
"dynamic": "strict",
"properties": {
"orderid": { "type": "string"},
"orderdetails": {
"type": "object",
"dynamic": true
}
}
}
}
}
PUT /emporders/empid/1
{
"orderid": "order1",
"orderdetails": {
"item1": "Jacket",
"item2": "Shaving kit"
}
}
PUT /emporders/empid/2
{
"orderid": "order2",
"orderdetails": {
"item1": "Cooking Gas Stove"
}
}
---
### Author:  [@aymanm](https://discuss.elastic.co/u/aymanm)
#### Post date: [February 25, 2017, 6:41pm UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-input-for-mutliple-table-joins-of-one-to-many-relationships/59933/4 "2017-02-25T18:41:27Z")
I know this is an older question and you probably have resolved it by now. But I came across a similar issue and took me a while to figure out.
One way is to use a JOIN in your sql query and then use the aggregate filter. Please see this reference example #4
[https://www.elastic.co/guide/en/logstash/current/plugins-filters-aggregate.html#\_example\_4\_no\_end\_event\_and\_tasks\_come\_one\_after\_the\_other](https://www.elastic.co/guide/en/logstash/current/plugins-filters-aggregate.html#_example_4_no_end_event_and_tasks_come_one_after_the_other)
---
### Author:  [@bsadagopan0107](https://discuss.elastic.co/u/bsadagopan0107)
#### Post date: [April 13, 2017, 2:42pm UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-input-for-mutliple-table-joins-of-one-to-many-relationships/59933/5 "2017-04-13T14:42:28Z")
Hi @Syed_Ather : I am having a similar requirement and would like to know if this was resolved and if so, through what approach ? Please explain.
Thanks,
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 4:27am UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-input-for-mutliple-table-joins-of-one-to-many-relationships/59933/6 "2017-07-06T04:27:04Z")