ElasticSearch: access document nested value in groovy script

Question

I have a document stored in ElasticSearch as below. _source:

 {
 "firstname": "John",
 "lastname": "Smith",
 "medals":[
           {
             "bucket": 100, 
             "count": 1
           },
           {
             "bucket": 150,
             "count": 2
           }
         ]
  }

I can access the string type value inside a document using doc.firstname for scripted metric aggregation http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/search-aggregations-metrics-scripted-metric-aggregation.html.

But I am not able to get the field value using doc.medals[0].bucket.

Can you please help me out and let me know how to access the values inside nested fields?

Aniket · Accepted Answer · 2015-01-14 22:34:38Z

9

Use _source for nested properties. Doc holds fields that are loaded in memory. Nested documents may not be loaded and should be accessed with _source.

For instance:

GET index/type
    {
     "aggs": {
      "NAME": {
      "scripted_metric": {
        "init_script": "_agg['collection']=[]",
        "map_script": "_agg['tr'].add(_source.propertry1.prop);",
        "combine_script": "return _agg",
        "reduce_script": "return _aggs"
      }
    }
  },
  "size": 0
}

answered Jan 14, 2015 at 22:34

Aniket

1,3861 gold badge11 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

ElasticSearch: access document nested value in groovy script

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related