Combining Join type with Nested type and querying in Elasticsearch 6.x
We ended up creating separate indices for each of these entities ( Customer, Order, Package etc) and querying against all of these indices from our application and combined the results in the app. This was the recommendation from the consultant we've been working with from Elasticsearch. We did not do the parent child relationship in any of the index mappings. This might be helpful for someone in the future.