Nested elasticsearch query for java QueryBuilders

Question

I am trying to achieve this elasticsearch query in java querybuilder for elasticsearch. But i am not able to get the equivalent results. Can anyone help with this.

 GET /XX/XX/_search
    {
       "query": {
          "bool": {
             "must": [
                {
                   "nested": {
                      "path": "XX",
                      "filter": {
                         "term": {
                            "A": "7:140453136:T"
                         }
                      }
                   }
                },
                {
                   "nested": {
                      "path": "XX",
                      "filter": {
                         "term": {
                            "B": "RF"
                         }
                      }
                   }
                },
                {
                   "nested": {
                      "path": "XX",
                      "filter": {
                         "term": {
                            "C": "RFFF"
                         }
                      }
                   }
                }
             ]
          }
       }
    }

The code which i tried:

   QueryBuilders qbWithArguments = QueryBuilders.boolQuery()
                    .must(QueryBuilders.termQuery("A", "RF"))
                    .must(QueryBuilders.termQuery("B", "EF"))
                    .must(QueryBuilders.termQuery("C", "RF"));

Dorian Turba · Accepted Answer · 2019-07-30 10:03:10Z

11

You need to add nested query too. Use below code:

QueryBuilders.boolQuery().must(nestedQuery("XX", FilterBuilders.termFilter("A","RF")))
                             .must(nestedQuery("XX", FilterBuilders.termFilter("B","EF")))
                             .must(nestedQuery("XX", FilterBuilders.termFilter("C","RF")))

For higher versions you can use :

QueryBuilders.boolQuery().must(nestedQuery("XX", QueryBuilders.boolQuery()
           .should(QueryBuilders.termQuery("A","RF"))
           .should(QueryBuilders.termQuery("B","EF"))
           .should(QueryBuilders.termQuery("C","RF"))
           .minimumShouldMatch("1")))

Notes: In 6.7, even if the doc stayed that ScoreMode is optional, you may need to provide this param when using the java QueryBuilders.

edited Jul 30, 2019 at 10:03

Dorian Turba

4,0413 gold badges30 silver badges82 bronze badges

answered Jan 29, 2016 at 2:54

Richa

7,6796 gold badges30 silver badges36 bronze badges

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

7 Comments

Abhi.G Over a year ago

nestedQuery() doesnt accept FilterBuilders as second argument. It expects QueryBuilder.

Richa Over a year ago

There is an overloaded method in QueryBuilders class which accepts filterbuilder as second argument. public static NestedQueryBuilder nestedQuery(String path, FilterBuilder filter) { return new NestedQueryBuilder(path, filter); }. Refer to rajish.github.io/api/elasticsearch/0.20.0.Beta1-SNAPSHOT/org/…

Abhi.G Over a year ago

Thanks for the reference. But i am using ES 2.1.1 which is the latest and i dont see that overloaded method in the latest API doc.

Abhi.G Over a year ago

FYI: org.elasticsearch.index.queries.FilterBuilders has been removed as part of the merge of queries and filters. These filters are now available in QueryBuilders with the same name. All methods that used to accept a FilterBuilder now accept a QueryBuilder instead.

Richa Over a year ago

Can you use QueryBuilders then? I have edited my answer according to that.

|

Collectives™ on Stack Overflow

Nested elasticsearch query for java QueryBuilders

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related