Elastic Search: include multiple field in query

Question

I am new to Elastic Search.I want to include multiple field in my search query something like:

      Title=my title and city=mycity or country = mycountry

How can I execute this kind of query using java client? I tried this

SearchResponse response = client.prepareSearch("titan")
    .setTypes("vertex")
    .setSearchType(SearchType.QUERY_AND_FETCH)
    .setQuery(QueryBuilders.fieldQuery("title", "mytitle"))
    .setQuery(QueryBuilders.fieldQuery("city", "mycity"))
    .setFrom(0).setSize(60).setExplain(true)
    .execute()
    .actionGet();

but didn't work

Ashalynd · Accepted Answer · 2014-05-17 10:48:14Z

1

You have to do booleanQuery there, I believe.

Something like:

SearchResponse response = client.prepareSearch("titan")
    .setTypes("vertex")
    .setSearchType(SearchType.QUERY_AND_FETCH)
    .setQuery(QueryBuilders.boolQuery()
    .must(QueryBuilders.fieldQuery("title", "mytitle"))
    .should(QueryBuilders.fieldQuery("city", "mycity"))
    .should(QueryBuilders.fieldQuery("country", "mycountry")))
    .setFrom(0).setSize(60).setExplain(true)
    .execute()
    .actionGet();

The rules for boolean queries, in a nutshell, are that all must clauses are expected to be true, and at least one from the should clauses are expected to be true (the amount of should clauses which has to be true can be changed, one is the default).

answered May 17, 2014 at 10:48

Ashalynd

12.6k2 gold badges36 silver badges38 bronze badges

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

4 Comments

Manish Kumar Over a year ago

.must(QueryBuilders.fieldQuery("country", "IN")) it work but if i use .must(QueryBuilders.fieldQuery("country", "in")) it doesnt. why?

Ashalynd Over a year ago

Perhaps you country field is not analyzed?

Manish Kumar Over a year ago

then why it is fetching for IN

Ashalynd Over a year ago

I guess because when it's indexing the data, the country field is provided as "IN", and perhaps in the mapping it is specified as "not analyzed". that means it's not tokenized and taken as-is (case-sensitive, among other things). But it's just a guess, for the exact answer you need to know how the data are indexed.

Collectives™ on Stack Overflow

Elastic Search: include multiple field in query

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related