How to compare field with _id in elasticsearch script?

Question

{
   "query":{
      "bool":{
         "must":{
            "match_all":{

            }
         },
         "filter":[
            {
               "script":{
                  "source":"doc['id'].value == doc['_id'].value",
                  "lang":"painless"
               }
            }
         ]
      }
   },
   "track_total_hits":true
}

So doc['_id'].value is the line that causing error. How should i compare field value with _id value?

In normal documents "_id" is string and "id" is long, but i broke a few and now in them both are strings, how could I find them?

What is the error you're getting? – Val Dec 08 '19 at 08:16 — Val, Dec 08 '19 at 08:16

score 1 · Accepted Answer · answered Dec 09 '19 at 06:10

1

I think your id field type is keyword, so; you can't call doc['id'].value without .keyword.

try this:

"script": {
    "script": {
        "source": "doc['id.keyword'].value == doc['_id'].value",
        "lang": "painless"
    }
}

answered Dec 09 '19 at 06:10

Nimer Awad

3,967
3
17
31

1

It's not keyword but i missed `"script":{"script": ...}` – user12496039 Dec 19 '19 at 08:57

How to compare field with _id in elasticsearch script?

1 Answers1