return nested fields using elastic4s

Question

I have data stored with a nested location object and can't figure out how to get elastic4s to return the location as part of the result of a search. I have data that when queried (from the REST endpoint) looks like this:

{
    "_index": "us_large_cities",
    "_type": "city",
    "_id": "AU7ke-xU_N_KRYZ5Iii_",
    "_score": 1,
    "_source": {
        "city": "Oakland",
        "state": "CA",
        "location": {
            "lat": "37.8043722",
            "lon": "-122.2708026"
        }
    }
}

When I try querying it using elastic4s like so:

search in "us_large_cities"->"city" fields("location", "city", ) query {
filteredQuery filter {
  geoPolygon("location") point(37.9, -122.31) point(37.8, -122.31) point(37.8, -122.25) point(37.9, -122.25)
}

I get back results like this:

{
  "_index" : "us_large_cities",
  "_type" : "city",
  "_id" : "AU7keH9l_N_KRYZ5Iig0",
  "_score" : 1.0,
  "fields" : {
    "city" : [ "Berkeley" ]
  }
}

Where I would expect to see "location" but don't. Does anyone know how I specify the fields so that I can actually get the location?

Val · Accepted Answer · 2015-08-03 19:01:17Z

1

You should try using source filtering instead, as shown below. Note the use of sourceInclude instead of fields.

search in "us_large_cities"->"city" sourceInclude("location", "city") query {
filteredQuery filter {
  geoPolygon("location") point(37.9, -122.31) point(37.8, -122.31) point(37.8, -122.25) point(37.9, -122.25)
}

answered Aug 3, 2015 at 19:01

Val

218k14 gold badges377 silver badges384 bronze badges

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

2 Comments

Danny Hatcher Over a year ago

This works! I just have to then call .getSource on the hits instead of calling .getFields etc.

sksamuel Over a year ago

@DannyHatcher FYI source and fields are different, fields show you what it looks like after tokenization and source is the original document in json.

Collectives™ on Stack Overflow

return nested fields using elastic4s

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