Search multiple indices for an ID efficiently?

Question

I need to get a document but I have no idea what index it is in. I have a bunch of indices for different days; all prefixed with "mydocs-". I've tried:

GET /mydocs-*/adoc/my_second_doc

returns "index_not_found_exception"


GET /mydocs-*/adoc/_search
{
"query": {
  "bool":{
    "filter": [{
      "term":{
      "_id": ["my_second_doc"] 
    }
    }]
  }
  }
}

returns all the docs in the index.

Now, if I search the specific index I can get the doc. Problem is that I don't always know the index it is in beforehand. So, I'd have to search many, many indices for it (thousands of indices).

GET /mydocs-12/adoc/my_second_doc

returns the desired doc.

Any ideas on how to do an efficient Get/Search for the doc?

Have you tried `GET /mydocs-*/adoc/_search?q=_id:my_second_doc` ? — Val, Aug 18 '17 at 04:02

sunkuet02 · Accepted Answer · 2017-08-18T06:07:50.717

Have you tried with :

GET mydocs-*/adoc/_search
{
  "query": {
        "term": {
            "_id": "my_second_doc"
        }
   }
}

Or more specifically with :

GET mydocs-*/_search
{
  "query": {
    "bool": {
        "must": [
           {
               "term": {
                  "_id": "my_second_doc"
               }
           },
           {
               "term": {
                  "_type": "adoc"
               }
           }
        ]
    }
  }
}

The above two queries will find all the documents whose index starting with mydocs-, type is adoc and id is my_second_doc.

Search multiple indices for an ID efficiently?

1 Answers1