Elasticsearch Java API - Bool Query Operator

Question

I am using Elasticsearch 2.4.3 in my Spring Boot App and use following Query

    QueryBuilder qb = new BoolQueryBuilder()
        .must(QueryBuilders.multiMatchQuery(term, "phoneticFirstName", "phoneticLastName", "phoneticLocationName", "phoneticCompanyName")
                .analyzer("atsCustomSearchAnalyzer")
                .operator(Operator.AND))
        .must(QueryBuilders.multiMatchQuery(term, "ngramFirstName^3", "ngramLastName^3", "ngramLocationName^3", "ngramCompanyName^3", "_all")
                .analyzer("atsCustomSearchAnalyzer")
                .operator(Operator.AND));

I want to get a response, where the first Query or the second Query get hits.... can you help me to change that in my Code, please?

UPDATE

        "atsCustomPhoneticAnalyzer":{
            "type":"custom",
            "tokenizer":"whitespace",
            "filter":["lowercase","asciifolding","atsPhoneticFilter"]
        },
        "atsCustomSearchAnalyzer":{
            "type":"custom",
            "tokenizer":"whitespace",
            "filter":["lowercase","asciifolding","umlautStemmer","germanStemmer"]   
        }

UPDATE #2

    QueryBuilder qb = new BoolQueryBuilder()
        .should(QueryBuilders.multiMatchQuery(term, "ngramFirstName", "ngramLastName", "ngramLocationName", "ngramCompanyName")
            .type(Type.CROSS_FIELDS)
            .analyzer("atsCustomSearchAnalyzer")
            .operator(Operator.AND)
            .boost(3))
        .should(QueryBuilders.multiMatchQuery(term, "phoneticLastName")
            .analyzer("atsCustomPhoneticAnalyzer")
            .operator(Operator.AND))
        .should(QueryBuilders.matchQuery(term, "_all")
                .analyzer("atsCustomSearchAnalyzer")
                .operator(Operator.AND))
        .minimumNumberShouldMatch(1);

I have 2 indices: persons and activities. When I comment out the second query I get Hits from persons and activities. If all 3 queries are present the hits from activities are not there anymore....

Any ideas?

Change must with should instead and add minimumShouldMatch(1) — Val
– Val, Commented Feb 1, 2017 at 12:21
Thanks Val, it works! But my Koelnerphonetic Query will not work :( it handles such things like "Mayer / Maier / Meyer / Meier" and say that these ones are sounds same ... in my question I've updated my Mapping/Setting for this — Timo Ademeit
– Timo Ademeit, Commented Feb 1, 2017 at 12:30
Ok, nvm ..... I just used the wrong analyzer in the first query — Timo Ademeit
– Timo Ademeit, Commented Feb 1, 2017 at 12:33

Val · Accepted Answer · 2017-02-01 14:23:25Z

4

Simply change must with should instead and add minimumShouldMatch(1)

QueryBuilder qb = new BoolQueryBuilder()
    .minimumNumberShouldMatch(1)
    .should(QueryBuilders.multiMatchQuery(term, "phoneticFirstName", "phoneticLastName", "phoneticLocationName", "phoneticCompanyName")
            .analyzer("atsCustomSearchAnalyzer")
            .operator(Operator.AND))
    .should(QueryBuilders.multiMatchQuery(term, "ngramFirstName^3", "ngramLastName^3", "ngramLocationName^3", "ngramCompanyName^3", "_all")
            .analyzer("atsCustomSearchAnalyzer")
            .operator(Operator.AND));

answered Feb 1, 2017 at 14:23

Val

218k14 gold badges377 silver badges384 bronze badges

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

9 Comments

Timo Ademeit Over a year ago

Thanks for the example - it worked! But now I've got another problem (see question Update #2)

Val Over a year ago

You need to use the correct analyzer, you have defined atsCustomPhoneticAnalyzer but you're referencing atsCustomSearchAnalyzer

Timo Ademeit Over a year ago

Added my CustomSearchAnalyzer to my mapping example in Question area

Val Over a year ago

Look at the names of the analyzers, they don't match with the one you're using in your query.

Val Over a year ago

Ok, now you've fixed it. I'd say that this new issue would warrant another question, the initial one being solved.

|

Collectives™ on Stack Overflow

Elasticsearch Java API - Bool Query Operator

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related