How to request a single document by _id via alias?

Question

Is it possible to request a single document by its id by querying an alias, provided that all keys across all indices in the alias are unique (it is an external guarantee)?

Heschoon · Accepted Answer · 2015-03-12T19:52:33.257

16

Yes, querying an alias spanning over multiple indices work the same way as querying one indice.

Just do this query over the alias:

POST my_alias_name/_search
{
    "filter":{
        "term":{"_id": "AUwNrOZsm6BwwrmnodbW"}
    }
}

EDIT: GET operations are not real searches and can't be done on aliases spanning over multiple indexes. So the following query is in fact no permitted:

GET my_alias_name/my_type/AUwNrOZsm6BwwrmnodbW

edited Mar 12 '15 at 19:52

answered Mar 12 '15 at 14:02

Heschoon

2,915
9
26
55

It says `{ "error" : "ElasticsearchIllegalArgumentException[Alias [data] has more than one indices associated with it [[data_2014-05-31, data_2014-06-26]], can't execute a single index op]", "status" : 400 }` – Mischa Arefiev Mar 12 '15 at 15:20
Even with the second request? – Heschoon Mar 12 '15 at 15:48
The second one works, thank you. Although it is kind of slow. – Mischa Arefiev Mar 13 '15 at 09:42

score 16 · Answer 2 · answered Oct 11 '17 at 07:08

From Elasticsearch 5.1 the query looks like:

GET /my_alias_name/_search/
{
    "query": { 
        "bool": {
         "filter": {
                "term": {
                   "_id": "AUwNrOZsm6BwwrmnodbW"
                }
            }
        }
    }
}

score 8 · Answer 3 · answered May 08 '22 at 09:16

8

Following Elasticsearch 8.2 Doc, you can retrieve a single document by using GET API:

GET my-index-000001/_doc/0

answered May 08 '22 at 09:16

Cong

131
1
5

This does not work if you have an alias with multiple indexes. You get the error above "has more than one index associated with it". – bschulz Aug 15 '23 at 22:01

score 3 · Answer 4 · answered Jul 18 '19 at 12:10

7.2 version Docs suggest:

GET /_search
{
    "query": {
        "ids" : {
            "values" : ["1", "4", "100"]
        }
    }
}

Response should look like:

{
  "took": 0,
  "timed_out": false,
  "_shards": {
    "total": 2,
    "successful": 2,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 1,
      "relation": "eq"
    },
    "max_score": 1.0,
    "hits": [
      {
        "_index": "indexwhatever",
        "_type": "_doc",
        "_id": "anyID",
        "_score": 1.0,
        "_source": {
          "field1": "value1",
          "field2": "value2"
        }
      }
    ]
  }
}

score 2 · Answer 5 · answered Apr 03 '20 at 16:17

2

In case you want to find a document with some internal id with curl:

curl -X GET 'localhost:9200/_search?q=id:42&pretty'

answered Apr 03 '20 at 16:17

Aliaksei

1,094
11
20

How to request a single document by _id via alias?

5 Answers5

Linked