# Realtime search based on 2 indexes

**URL:** <https://discuss.elastic.co/t/realtime-search-based-on-2-indexes/240402>\
**Category:** Elasticsearch\
**Created:** [July 8, 2020, 4:27pm UTC](https://discuss.elastic.co/t/realtime-search-based-on-2-indexes/240402 "2020-07-08T16:27:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mexekanez](https://avatars.discourse-cdn.com/v4/letter/m/73ab20/32.png) [@mexekanez](https://discuss.elastic.co/u/mexekanez)\
**Post date:** [July 8, 2020, 4:27pm UTC](https://discuss.elastic.co/t/realtime-search-based-on-2-indexes/240402/1 "2020-07-08T16:27:14Z")

</div>

Hello to all!

I need some kind of advice, so in general, I have 2 indexes:

1. The first index its aliases ex: my\_name -\> Barak Trump (an amount in first interactions about 50 000 can be much more)

2. Seconds Index it's a huge amount of documents (about 8M records with raw text from google OCR)

So how can I find aliases match from the first index in second???

Iterate in realtime one alias -\> one query = it's the dead way I will meet all timeouts which are possible.

So I asking real advice on how anybody solved this?

Best regards, Ivan!

---

<div class="post-metadata">

**Author:** ![mexekanez](https://avatars.discourse-cdn.com/v4/letter/m/73ab20/32.png) [@mexekanez](https://discuss.elastic.co/u/mexekanez)\
**Post date:** [July 8, 2020, 4:47pm UTC](https://discuss.elastic.co/t/realtime-search-based-on-2-indexes/240402/2 "2020-07-08T16:47:24Z")

</div>

will works something like this:

```auto
    {
        "query": {
            "bool": {
                "must": [
                    {
                        "match_phrase": {
                          "file_path": "charts/20190609/5cfcd176b70ba.pdf"
                        }
                    }
                ],
                "filter": {
                    "bool": {
                        "should": [
                            {
                                "query_string": {
                                    "query": "aliases_master_07_08_2020_13_46.alias_master_name",
                                    "analyze_wildcard": true,
                                    "default_field": "*"
                                }
                            }
                        ]
                    }
                }
            }
        }
    }

```

---

<div class="post-metadata">

**Author:** ![mexekanez](https://avatars.discourse-cdn.com/v4/letter/m/73ab20/32.png) [@mexekanez](https://discuss.elastic.co/u/mexekanez)\
**Post date:** [August 1, 2020, 11:12am UTC](https://discuss.elastic.co/t/realtime-search-based-on-2-indexes/240402/3 "2020-08-01T11:12:23Z")

</div>

@elastick

---

<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:** [August 1, 2020, 11:57am UTC](https://discuss.elastic.co/t/realtime-search-based-on-2-indexes/240402/4 "2020-08-01T11:57:47Z")

</div>

What you are describing is a join between two indices which Elasticsearch does not support. I would recommend looking at replacing your alias/synonym index with [search time synonyms](https://www.elastic.co/guide/en/elasticsearch/reference/current/analysis-synonym-tokenfilter.html).

---

<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:** [August 29, 2020, 11:57am UTC](https://discuss.elastic.co/t/realtime-search-based-on-2-indexes/240402/5 "2020-08-29T11:57:49Z")

</div>

Closed on August 29, 2020, 11:57am UTC

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