Search in two indexes

[Tomo_M (Tomohiro Mitani)]

This transform approach could be another option, while there are some tradeoffs.

How to join two index

I like to add another option: transform. A transform in a nutshell is a task that runs aggregation queries and persists the result in an index. In order to join 2 indices you need compatible mappings for grouping, e.g. a key that is named the same way and has the same type. Note, this can be achieved with scripts or runtime fields, however if you want to run in it continuously at scale, it is advised to use proper ordinary mappings. For the group_by use terms on the common key. For the aggreg…