# Is it possible to JOIN different indexes? Or is there a way to achieve an equivalent effect?

**URL:** <https://discuss.elastic.co/t/is-it-possible-to-join-different-indexes-or-is-there-a-way-to-achieve-an-equivalent-effect/239059>\
**Category:** Elasticsearch\
**Created:** [June 29, 2020, 5:36am UTC](https://discuss.elastic.co/t/is-it-possible-to-join-different-indexes-or-is-there-a-way-to-achieve-an-equivalent-effect/239059 "2020-06-29T05:36:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![fuqda](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fuqda/32/71280_2.png) [@fuqda](https://discuss.elastic.co/u/fuqda)\
**Post date:** [June 29, 2020, 5:36am UTC](https://discuss.elastic.co/t/is-it-possible-to-join-different-indexes-or-is-there-a-way-to-achieve-an-equivalent-effect/239059/1 "2020-06-29T05:36:57Z")

</div>

Is it possible to JOIN different indexes? Or is there a way to achieve an equivalent effect?  
If you change the existing mapping, I think you will have to re-populate the index with data again.  
I would like to create a new index and join it with an index that already contains data without changing the existing mapping.  
If I can't do this, is there no choice but to create a new index and reinsert the data based on the newly defined mapping?  
I would be happy to teach you.

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [June 29, 2020, 6:17am UTC](https://discuss.elastic.co/t/is-it-possible-to-join-different-indexes-or-is-there-a-way-to-achieve-an-equivalent-effect/239059/2 "2020-06-29T06:17:19Z")

</div>

Elasticsearch does not support joins. If you can provide additional information about your data and use-case, someone from the community may be able to identify possible workarounds.

---

<div class="post-metadata">

**Author:** ![fuqda](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fuqda/32/71280_2.png) [@fuqda](https://discuss.elastic.co/u/fuqda)\
**Post date:** [June 29, 2020, 6:31am UTC](https://discuss.elastic.co/t/is-it-possible-to-join-different-indexes-or-is-there-a-way-to-achieve-an-equivalent-effect/239059/3 "2020-06-29T06:31:48Z")

</div>

Thank you for your answer.  
I haven't been able to organize the information, so I'll sort it out again and ask another question if there's any progress.  
I'm glad to see that my hypothesis about not being able to do joins between indexes was correct, at a minimum.

---

<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:** [July 27, 2020, 6:31am UTC](https://discuss.elastic.co/t/is-it-possible-to-join-different-indexes-or-is-there-a-way-to-achieve-an-equivalent-effect/239059/4 "2020-07-27T06:31:53Z")

</div>

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