Range queries in Elasticsearch Java API

Question

I have two fields in my ES index: min_duration and max_duration. I want to create a query to find all the documents for input duration such that :

min_duration<=duration<=max_duration

For example if duration is 30 seconds then I should get all docs having min_duration less than eq to duration and duration less than eq to max_duration.

I am using ES Java API and seems like range filter is the way to go. I have constructed the range filter as follows:

val filter = FilterBuilders.andFilter( FilterBuilders.rangeFilter("min_duration").lte(duration),FilterBuilders.rangeFilter("max_duration").gte(duration))

Though it still not seems to work for me. Is it the correct way to build this type of query or am I missing something?

Thanks.

ChintanShah25 · Accepted Answer · 2016-01-15 01:16:39Z

6

Try doing it with bool query. Wrap your two range clauses inside it like

QueryBuilder qb = boolQuery()
    .must(rangeQuery("max_duration").gte(duration))
    .must(rangeQuery("min_duration").lte(duration));

Does this help?

answered Jan 15, 2016 at 1:16

ChintanShah25

12.7k3 gold badges45 silver badges44 bronze badges

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

Collectives™ on Stack Overflow

Range queries in Elasticsearch Java API

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related