elasticsearch aggregation using a script to transform field value being aggregated

Question

I currently have something like:

"aggs": {
        "group_by_myfield": {
            "terms": {
                "field": "myfield"
            }
        }
    }

However the value for myfield is "alpha 1.0", "alpha 2.0", "beta 1.0". Now I want to only aggregate over the values "alpha", "beta". How do I do that? I tried:

"aggs": {
        "group_by_myfield": {
            "terms": {
                "field": "myfield"
                "script": "_value.split()[0]"
            }
        }
    }

But I guess there is no split functionality. Any suggestions are welcome!

I found a similar question here which is unanswered as well.

β.εηοιτ.βε · Accepted Answer · 2019-08-27 09:27:45Z

8

I managed to get it done using the link I pasted in my question:

GET _search
{
    "size": 0, 
    "aggs": {
        "group_by_myfield": {
            "terms": {
                "field": "myfield",
                "script": "_value.replaceAll('\\\\s+.*','')"
            }
        }
    }
}

edited Aug 27, 2019 at 9:27

β.εηοιτ.βε

40.4k14 gold badges81 silver badges104 bronze badges

answered Apr 25, 2014 at 1:13

bagi

6271 gold badge8 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

elasticsearch aggregation using a script to transform field value being aggregated

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