Elasticsearch Nested Query into Java API

Question

I was new to Elasticsearch and Java. I was trying to convert a nested elasticsearch query which has both MUST and SHOULD functions. Can someone help on this.

GET /list/_search
{
  "size": 12,
  "query": {
    "bool": {
      "must": [
        {
          "bool": {
            "should": [
              {
                "multi_match": {
                  "query": "city hed",
                  "type": "bool_prefix",
                  "fields": [
                    "cityName":"",
                    "countryCodeName":"",
                    "iso":""
                  ]
                }
              },
              {
                "multi_match": {
                  "query": "city hed",
                  "fuzziness": "AUTO",
                  "fields": [
                    "cityName*"
                    ]
                }
              }
            ]
          }
        },
        {
          "bool": {
            "should": [
              {
                "match": {
                  "iso": ""
                }
              },
              {
                "match": {
                  "iso": ""
                }
              }
            ]
          }
        }
      ]
    }
  }
}

need method logic for it like how it will be in Java API

rabbitbr · Accepted Answer · 2022-11-24 11:26:07Z

1

If you use Java High Client try this:

SearchRequest searchRequest = new SearchRequest("idx_name");
SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();

MultiMatchQueryBuilder matchQueryBuilder = QueryBuilders
    .multiMatchQuery("city hed")
    .type(Type.PHRASE_PREFIX)
    .field("cityName")
    .field("countryCodeName")
    .field("iso");

MultiMatchQueryBuilder matchQueryBuilder2 = QueryBuilders
    .multiMatchQuery("city hed")
    .fuzziness("2")
    .field("cityName*");

MatchQueryBuilder matchQuery01 = QueryBuilders.matchQuery("iso", "");
MatchQueryBuilder matchQuery02 = QueryBuilders.matchQuery("iso", "");

BoolQueryBuilder bool01 = QueryBuilders.boolQuery().should(matchQueryBuilder).should(matchQueryBuilder2);
BoolQueryBuilder bool02 = QueryBuilders.boolQuery().should(matchQuery01).should(matchQuery02);

BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery().must(bool01).must(bool02);

searchSourceBuilder.query(boolQueryBuilder);

searchRequest.source(searchSourceBuilder);

SearchResponse searchResponse = getClient().search(searchRequest, RequestOptions.DEFAULT);

edited Nov 24, 2022 at 11:26

answered Nov 23, 2022 at 12:28

rabbitbr

3,2712 gold badges8 silver badges20 bronze badges

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

1 Comment

Guest Over a year ago

Can't we do it without using var ?

Collectives™ on Stack Overflow

Elasticsearch Nested Query into Java API

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related