Calculating distance between two points in elastic search

Question

I am trying to return the distance between two points provided as latitude and longitude values. Here's what i have tried doing.

await this.esService.search({
            index: IndexName,
            body: {
                sort: [{ avg_rating: { order: "desc" } }],
                "script_fields" : {
                    "distance" : {
                        "lang": "painless",
                        "params" : {
                           "lat" : 47.1,
                           "lon" : 8.1
                        },
                        "script" : "doc[\u0027user.userAddresses[0].location\u0027].distanceInKm(lat,lon)"
                     }
                 },
                from: offset,
                size: take,
                query: finalQuery
            }
        })

I am recieving this error parsing_exception: [parsing_exception] Reason: Unknown key for a VALUE_STRING in [lang]. Is there anything wrong going on here ?

Val · Accepted Answer · 2021-08-31 08:04:41Z

1

You're almost there, you're just missing the script declaration

            "script_fields" : {
                "distance": {                  
                  "script" : {             <--- add this
                    "lang": "painless",
                    "params" : {
                       "lat" : 47.1,
                       "lon" : 8.1
                    },
                    "source" : "doc[\u0027user.userAddresses[0].location\u0027].distanceInKm(lat,lon)"
                       ^
                  }    |
                }      |
             },  also change this

answered Aug 31, 2021 at 8:04

Val

218k14 gold badges377 silver badges384 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user13963926 Over a year ago

Well actually after doing above i get this error now Unknown key for a START_OBJECT in [script].

Val Over a year ago

Which version of ES are you running? Script_fields are specified here

Collectives™ on Stack Overflow

Calculating distance between two points in elastic search

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related