elasticsearch: running a script over top hits aggregation fields

Question

I want to perform a terms aggregation and in every results bucket get the hit fields after a script manipulation was performed.

For example, if these are the documents:

{"age": 15, "firstName": "Dana", "lastName": "Miller"}
{"age": 15, "firstName": "Michelle", "lastName": "Bob"}
{"age": 32, "firstName": "Mary", "lastName": "Smith"}
{"age": 32, "firstName": "Anna", "lastName": "Taylor"}

The aggregation is by the "age" field, and the script is: "return 'doc['firstName'] + ' ' + doc['lastName']"

The results should be:

bucket 1 (age: 15):

"Dana Miller"
"Michelle Bob"

Buchet 2 (age 32):

Mary Smith
Anna Taylor

Is this possible in elasticsearch?

EDIT:

In addition, I'm looking for a way to run a script over multiple hits in a bucket. For example, if we use the documents above and the terms aggregation by the age field, can I get the results of the hits in the bucket together in the following way?

Bucket 1 (age 15):

"Dana Miller and Michelle Bob"

Bucket2 (age 32):

"Mary Smith and Anna Taylor"

Is it possible in ES?

thank you.

Richa · Accepted Answer · 2017-06-19 06:32:03Z

1

I guess Following Query can help you.

{
"size": 0,
"aggs": {
  "group By age": {
     "terms": {
        "field": "age"
     },
     "aggs": {
        "top hits": {
           "top_hits": {
              "script_fields": {
                 "Name": {
                    "script": "doc['firstName'].value + ' ' + doc['lastName'].value "
                  }
                 }
              }
           }
        }
      }
   }
  }

Hope this helps!!

answered Jun 19, 2017 at 6:32

Richa

7,6796 gold badges30 silver badges36 bronze badges

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

3 Comments

Shani Over a year ago

thank you. can you also run a script over multiple buckets?

Shani Over a year ago

Your answer helped. I also added to the question above another question: run a script over the results of multiple buckets. For example, get the following result for bucket 1: "Dana Miller and Michelle Bob".

Shani Over a year ago

I'm sorry: run a script over multiple hits in a bucket (not multiple buckets).

Collectives™ on Stack Overflow

elasticsearch: running a script over top hits aggregation fields

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related