Elasticsearch filter in Aggregation data

Question

I would like to make query that like 'sql having' in ES java api.

select * from table group by oid having count(1) > 10

Here is I made but cannot add filter method.

.aggregation( 
            AggregationBuilders.terms( "aggs").field( "oid").filter... // cannot add filter method

Should I use .script for this?

Val · Accepted Answer · 2016-04-07 10:00:27Z

1

You can use the min_doc_count setting for this:

.aggregation( 
        AggregationBuilders.terms("aggs")
             .field( "oid")
             .minDocCount(10)                 <----- add this

answered Apr 7, 2016 at 10:00

Val

218k14 gold badges377 silver badges384 bronze badges

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

1 Answer 1