Using Elasticsearch internal "_id" in joining

[jadrol]

Hello

I would like to join records using ES internal _id field.

Something like this:

curl -XPOST http://localhost:9200/clients/client/1 -d'{
  "firstname": "john",
  "lastname": "smith",
  "id": 1, // for test purpose, if I specify this in "path" it works
  ...
}'

curl -XPOST http://localhost:9200/events/profile -d'{
  "client_id": 1,
  "test": "true",
  ....
}'

curl -XGET http://localhost:9200/events/profile/_coordinate_search?pretty -d'{
  "query": {
    "filtered": {
      "query": {
        "match_all": {}
      },
      "filter": {
        "filterjoin": {
          "client_id": {
            "indices": [ "clients" ],
            "types": [ "client" ],
            "path": "_id",
            "query": {
              "bool": {
                "must": [
                  { "term": { "firstname": "john" } }
                ]
              }
            }
          }
        }
      }
    }
  }
}'

But I'm getting no hits there, when I use "id" from document source it is working. Is there possibility to achieve "_id" to be working.

I'm using Elasticsearch 2.3.3.

Regards

[scampi]

This issue is tracked in https://github.com/sirensolutions/siren-join/issues/63. In the comments there some solution is proposed.