ElasticSearch: Provide inline script using Java API

Question

I need to build an aggregation using Java API:

GET /sales/t/_search
{
  "aggs": {
    "group_by_month": {
      "terms": {
        "script": "def opDate = new DateTime(doc['date'].date); opDate.getMonthOfYear()",
        "order": {
          "_term": "asc"
        }
      }
    }
  }
}

Up to now, I've been able to create an terms aggregation, however, I'm not able to provide the script:

AggregationBuilders.terms(this.getName()).field(this.getName()).script(??????????)

Which's the way to provide an inline script using Java API?

Val · Accepted Answer · 2016-08-11 07:56:55Z

2

Simply like this (no need for field() call by the way):

AggregationBuilders.terms(this.getName())
    .script(new Script("def opDate = new DateTime(doc['date'].date); opDate.getMonthOfYear()"))

Note, though, that your script can be much simpler, like this:

doc['date'].date.getMonthOfYear()

The reason is because doc['date'].date is already a DateTime instance

edited Aug 11, 2016 at 7:56

answered Aug 11, 2016 at 7:32

Val

218k14 gold badges377 silver badges384 bronze badges

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

2 Comments

Jordi Over a year ago

Solved! Thanks. Nevertheless, this aggregation returns me an 'LongTerms' bucketing aggregation result with each month as a double. Is there any way to set the terms aggregation bucket are longs instead of doubles?

Jordi Over a year ago

Sorry, it returns me an DoubleTerms

Collectives™ on Stack Overflow

ElasticSearch: Provide inline script using Java API

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