# Index Joined sql data in Elasticsearch via logstash

**URL:** https://discuss.elastic.co/t/index-joined-sql-data-in-elasticsearch-via-logstash/200421
**Category:** Logstash
**Created:** [September 20, 2019, 12:49pm UTC](https://discuss.elastic.co/t/index-joined-sql-data-in-elasticsearch-via-logstash/200421 "2019-09-20T12:49:26Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![sharko](https://avatars.discourse-cdn.com/v4/letter/s/77aa72/32.png) [@sharko](https://discuss.elastic.co/u/sharko)
#### Post date: [September 20, 2019, 12:49pm UTC](https://discuss.elastic.co/t/index-joined-sql-data-in-elasticsearch-via-logstash/200421/1 "2019-09-20T12:49:26Z")

</div>

Hello ,

I am trying to index already joined sql data into elastic search via logstash

the data I read look like this

```
{"family": "ABC", "person":{"name":"aaa","surname":"bbb"}} 
{"family": "ABC", "person":{"name":"ccc","surname":"ddd"}} 

```

I want it to be indexed like this considering that family is my "document\_id"

```
{ 
   "family":"ABC",
   "person":[ 
      { 
         "name":"aaa",
         "surname":"bbb"
      },
      { 
         "name":"ccc",
         "surname":"ddd"
      }
   ]
}

```

and if I receive a new event for family ABC the new person goes to the list

What will be the logstash filter??

Any help will be appreciated

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: [October 18, 2019, 12:49pm UTC](https://discuss.elastic.co/t/index-joined-sql-data-in-elasticsearch-via-logstash/200421/2 "2019-10-18T12:49:45Z")

</div>

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