ElasticSearch Java API "Should" Array

Question

I am trying to convert the following query to the ElasticSearch Java API:

GET /consumer/_search
{
  "query": {
    "bool": {
      "should": [
        {
          "bool": {
            "must": [
              {
                "match": {
                  "first_name": {
                    "query": "Peter"
                  }
                }
              },
              {
                "match": {
                  "last_name": {
                    "query": "Parker"
                  }
                }
              }
            ]
          }
        },
        {
          "bool": {
            "must": [
              {
                "match": {
                  "first_name": {
                    "query": "Parker"
                  }
                }
              },
              {
                "match": {
                  "last_name": {
                    "query": "Peter"
                  }
                }
              }
            ]
          }
        }
      ]
    }
  }
}

I tried the following :

query = QueryBuilders.boolQuery()
    .should(QueryBuilders.boolQuery()
    .must(QueryBuilders.matchQuery("first_name", "Peter").type(null))
    .must(QueryBuilders.matchQuery("last_name""Parker").type(null))
    .must(QueryBuilders.matchQuery("first_name","Parker").type(null))
    .must(QueryBuilders.matchQuery("last_name","Peter").type(null)))

I also tried :

 .should(QueryBuilders.boolQuery()
 .must(QueryBuilders.matchQuery("first_name", "Peter").type(null))
 .must(QueryBuilders.matchQuery("last_name", "Parker").type(null))
 .should(QueryBuilders.boolQuery()
 .must(QueryBuilders.matchQuery("first_name", "Parker").type(null))
 .must(QueryBuilders.matchQuery("last_name", "Peter").type(null))))

But none of them produced the same query that I created. Any idea about how I can create this?

In a few words, the first query is doing the following :

Select * from consumer where first_name='Peter' and last_name='Parker' OR first_name='Parker' and last_name='Peter'

Thank you

Community · Accepted Answer · 2017-05-23 11:47:14Z

5

I think your second attempt was close, you need to close the first should clause. Try this

query = QueryBuilders.boolQuery()
        .should(QueryBuilders.boolQuery()
            .must(QueryBuilders.matchQuery("first_name", "Peter").type(null))
            .must(QueryBuilders.matchQuery("last_name", "Parker").type(null)))
        .should(QueryBuilders.boolQuery()
            .must(QueryBuilders.matchQuery("first_name", "Parker").type(null))
            .must(QueryBuilders.matchQuery("last_name", "Peter").type(null)))

You can also pass JSON string to wrapperQuery, have a look at this SO question

edited May 23, 2017 at 11:47

CommunityBot

11 silver badge

answered Oct 4, 2016 at 3:50

ChintanShah25

12.7k3 gold badges45 silver badges44 bronze badges

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

Collectives™ on Stack Overflow

ElasticSearch Java API "Should" Array

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