Include NULL values in Range Query Elasticsearch

Question

I have framed Range query as below - Java High Level REST Client

QueryBuilder rangeQu = QueryBuilders.rangeQuery("price").gt(30).lt(5000);

In this I want to include NULL/Empty values as well. How to include it?

Combine your query with a "not exists"-Query via boolean-"OR". elastic.co/guide/en/elasticsearch/reference/current/… — Karsten R.
– Karsten R., Commented Aug 18, 2018 at 8:28
I understand from elastic query but need to know how to do with Java High Level REST client? — syv
– syv, Commented Aug 18, 2018 at 9:49

Remot · Accepted Answer · 2018-08-19 19:10:29Z

2

Creating a bool query that takes either the range query or the not exist should work something like this:

BoolQueryBuilder queryFilter = QueryBuilders.boolQuery();
queryFilter.should(QueryBuilders.rangeQuery("price").gt(30).lt(5000));
queryFilter.should(QueryBuilders.boolQuery().mustNot(QueryBuilders.existsQuery("price")));

answered Aug 19, 2018 at 19:10

Remot

1841 silver badge4 bronze badges

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

Collectives™ on Stack Overflow

Include NULL values in Range Query Elasticsearch

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related