how to return all fields when using scripted fields in elastic search

Question

Using elastic search I'm trying to add a calculated distance field to a geo search. I just want to append an extra calculated field to the search document but when I add the calculated field via "script_fields", then only that field is returned.

I tried adding a wildcard fields part, but it didn't affect the result.

How to make this query return the complete documents with the extra calculated field added?

GET /ocsm_test/inventory/_search
{
  "query": {
    "bool": {
      "must": {
        "match_all": {}
      },
      "filter": {
        "geo_distance": {
          "distance": "2km",
          "address.geo.location": [],
          "loc.address.geo.location": [
            151.2165507,
            -33.8732887
          ]
        }
      }
    }
  },
  "aggs": {
    "partNumber": {
      "terms": {
        "field": "partNumber",
        "order": {
          "_term": "asc"
        }
      }
    },
    "location": {
      "terms": {
        "field": "loc.identifier",
        "order": {
          "_term": "asc"
        }
      }
    }
  },
  "script_fields": {
    "distance": {
      "params": {
        "lat": -33.8732887,
        "lon": 151.2165507
      },
      "script": "doc['loc.address.geo.location'].distanceInKm(lat,lon)"
    }
  },
  "fields": [
    ".*"
  ],
  "post_filter": {
    "bool": {
      "must": [
        {
          "term": {
            "partNumber": "p-0099393-3"
          }
        }
      ]
    }
  }
}

Try using "_source": true instead of "fields"

Val
– Val

2016-04-26 08:16:02 +00:00
Commented Apr 26, 2016 at 8:16 — Val
– Val, Commented Apr 26, 2016 at 8:16
that worked, thanks Val.

Richard G
– Richard G

2016-04-26 11:54:17 +00:00
Commented Apr 26, 2016 at 11:54 — Richard G
– Richard G, Commented Apr 26, 2016 at 11:54

Val · Accepted Answer · 2016-04-26 11:59:00Z

13

Retrieving fields is not recommended, you should use source filtering instead.

So, instead of this

"fields": [
  ".*"
],

Use this:

"_source": true

answered Apr 26, 2016 at 11:59

Val

218k14 gold badges377 silver badges384 bronze badges

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

1 Comment

Richard G Over a year ago

Thanks Val, I didn't realise there's source filtering available. I'll make use of that actually, not for this particular thing, but some others.

Collectives™ on Stack Overflow

how to return all fields when using scripted fields in elastic search

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related