# Map large, complex sql result set to document with nested objects
**URL:** https://discuss.elastic.co/t/map-large-complex-sql-result-set-to-document-with-nested-objects/84273
**Category:** Elasticsearch
**Created:** [May 2, 2017, 1:36pm UTC](https://discuss.elastic.co/t/map-large-complex-sql-result-set-to-document-with-nested-objects/84273 "2017-05-02T13:36:23Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Abid\_Hussain](https://discuss.elastic.co/u/Abid_Hussain)
#### Post date: [May 2, 2017, 1:36pm UTC](https://discuss.elastic.co/t/map-large-complex-sql-result-set-to-document-with-nested-objects/84273/1 "2017-05-02T13:36:23Z")
Hi there,
a similar question was asked here [Logstash jdbc plugin input for mutliple table joins of one to many relationships](https://discuss.elastic.co/t/logstash-jdbc-plugin-input-for-mutliple-table-joins-of-one-to-many-relationships/59933)
... but it seems not to be resolved until now.
The elasticsearch-jdbc plugin is able to map the results of a sql query containing joins (e.g. a query on a 1:n relationship) to a json structure containing nested objects.
Unfortunately, elasticsearch-jdbc does not support Elasticsearch 5 and higher.
I would like to index a relational structure containing about 10.000.000 entries to a document structure with nested objects. How can I achieve this?
It seems that logstash aggregate plugin may be an option, but is it able to handle a result set of such large size?
Regards,
Abid
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 30, 2017, 1:38pm UTC](https://discuss.elastic.co/t/map-large-complex-sql-result-set-to-document-with-nested-objects/84273/2 "2017-05-30T13:38:53Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.