# Maximum number & size of fields (nested) inside a document

**URL:** <https://discuss.elastic.co/t/maximum-number-size-of-fields-nested-inside-a-document/97772>\
**Category:** Elasticsearch\
**Created:** [August 21, 2017, 1:06pm UTC](https://discuss.elastic.co/t/maximum-number-size-of-fields-nested-inside-a-document/97772 "2017-08-21T13:06:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sumaya\_Baig](https://avatars.discourse-cdn.com/v4/letter/s/7cd45c/32.png) [@Sumaya\_Baig](https://discuss.elastic.co/u/Sumaya_Baig)\
**Post date:** [August 21, 2017, 1:06pm UTC](https://discuss.elastic.co/t/maximum-number-size-of-fields-nested-inside-a-document/97772/1 "2017-08-21T13:06:48Z")

</div>

Hello,  
I have an ES setup that has an index called customer with details of the customers (user\_id, name,age etc.) and I have created a separate index called transaction which has details of transactions (user\_id,date,item list (containing sku etc) etc.)  
I need to find the users who have purchased an item (sku) and who are gender female for example.  
Is there a way to join these two indices?  
If not, and I decide to add the transactions for each user as a nested object inside the customer mapping, what is the maximum number of fields (including nested objects) can each document have? And is there a maximum number of objects inside each item of the nested objects?  
The customer will have many fields such as vouchers, communications, offers, 1000s of transactions etc.

---

<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:** [September 18, 2017, 1:07pm UTC](https://discuss.elastic.co/t/maximum-number-size-of-fields-nested-inside-a-document/97772/2 "2017-09-18T13:07:22Z")

</div>

Closed on September 18, 2017, 1:07pm UTC

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