Elasticsearch failed to run inline script [doc....] using lang groovy

Question

I'm getting this error when trying to match all in my index, and display the distance between a given geo_point and the query results, I'm using DrTech's answer for the script to display the distance:

this is my DSL query:

{
  "query": {
    "match_all": {}
  },
  "script_fields": {
    "distance": {
      "lang": "groovy",
      "params": {
        "lat": 2.27,
        "lon": 50.3
      },
      "script": "doc['geo_coordinates'].distanceInKm(lat,lon)"
    }
  }
}

Query response:

{
  "took": 50,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 4,
    "failed": 1,
    "failures": [
      {
        "shard": 0,
        "index": "users",
        "node": "pa76fjdWQl2YAHmgCT4oKw",
        "reason": {
          "type": "script_exception",
          "reason": "failed to run inline script [doc['geo_coordinates'].distanceInKm(lat,lon)] using lang [groovy]",
          "caused_by": {
            "type": "null_pointer_exception",
            "reason": null
          }
        }
      }
    ]
  },
  "hits": {
    "total": 184,
    "max_score": 1,
    "hits": []
  }

and I have this in my mapping :

  "geo_coordinates" : {
            "type" : "geo_point",
            "lat_lon" : true
          },

so I don't understand why I'm getting a Null pointer !! .....

Is it possible that one of your documents has no `geo_coordinates` field ? — Val, Jun 15 '16 at 13:13
Impossible it does exist in my Mongodb and in my Elasticsearch mapping — ZEE, Jun 15 '16 at 13:13
I'm not talking about the mapping, but if you just have one single document instance which doesn't have any value for this field, that might explain the NPE. — Val, Jun 15 '16 at 13:14
There you go, then you should modify your script to only call `distanceInKm()` if the value exists. — Val, Jun 15 '16 at 13:16

score 5 · Accepted Answer · answered Jun 15 '16 at 13:19

5

It's probably because one of the documents doesn't have any value in the geo_coordinates field. Hence, you need to account for this case in your script.

Try this instead:

{
  "query": {
    "match_all": {}
  },
  "script_fields": {
    "distance": {
      "lang": "groovy",
      "params": {
        "lat": 2.27,
        "lon": 50.3
      },
      "script": "doc['geo_coordinates'] ? doc['geo_coordinates'].distanceInKm(lat,lon) : 0"
    }
  }
}

answered Jun 15 '16 at 13:19

Val

207,596
13
358
360

1

`"doc['geo_coordinates']?.distanceInKm(lat,lon) ?: 0"` should work as well – tim_yates Jun 15 '16 at 13:30
True, that's a shorter groovy way of achieving the same thing. – Val Jun 15 '16 at 13:44

Elasticsearch failed to run inline script [doc....] using lang groovy

1 Answers1