How to do search on elasticsearch using java api with a list as parameter

Question

I am trying to run a query in elasticsearch cluster from java api; I have a list of string values and I would like to get all documents which contains any one of those string values. How can I do it? I tried the following but did not work.

List<String> tagList = new ArrayList<String>();
tagList.add("grails");
tagList.add("elasticSearch");
tagList.add("java");
SearchResponse response = client.prepareSearch("mongoindex")
    .setSearchType(SearchType.QUERY_AND_FETCH)
    .setQuery(fieldQuery("tags", tagList))
    .setFrom(0).setSize(60).setExplain(true)
    .execute()
    .actionGet();

Hemed · Accepted Answer · 2016-12-23 23:43:12Z

1

It's late but maybe it can help someone else. You can build a terms query using bool query with should clause.

BoolQueryBuilder boolQuery = QueryBuilders.boolQuery()
                .should(QueryBuilders.termsQuery("tags", tagList));

After that continue as usual, assuming there exist a field tags which holds those values.

SearchResponse response = client.prepareSearch("mongoindex")
    .setSearchType(SearchType.QUERY_AND_FETCH)
    .setQuery(boolQuery)
    .setFrom(0).setSize(60).setExplain(true)
    .execute()
    .actionGet();

answered Dec 23, 2016 at 23:43

Hemed

939 bronze badges

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

Comments

Stanislav Milev · Accepted Answer · 2021-11-05 07:17:00Z

1

For youre purpose you need to create the query with separate terms so it will search for at least a single match. Something like this

BoolQueryBuilder boolQuery = QueryBuilders.boolQuery();
tagList.forEach(tag-> boolQuery.should(QueryBuilders.termQuery("tags", tag));
boolQuery.minimumShouldMatch(1);

And then use it in your search.

"minimumShouldMatch" is to be sure that at least on tag is present in a matched document.

answered Nov 5, 2021 at 7:17

Stanislav Milev

611 silver badge5 bronze badges

Comments

Alejandro · Accepted Answer · 2013-12-27 05:57:53Z

0

Try this one:

List<String> tagList = new ArrayList<String>();
tagList.add("grails");
tagList.add("elasticSearch");
tagList.add("java");
SearchResponse response = client.prepareSearch("mongoindex")
.setSearchType(SearchType.QUERY_AND_FETCH)
.setQuery(QueryBuilders.termsQuery("tags", tagList))
.setFrom(0).setSize(60).setExplain(true)
.execute()
.actionGet();

Check this link to see more details about the terms query.

answered Dec 27, 2013 at 5:57

Alejandro

8918 silver badges13 bronze badges

2 Comments

Eddard Stark Over a year ago

here, the field 'tags' is not an array, its a simple string field and I want to list all documents which have 'grails', 'elasticsearch' or 'java' in the field; any one of them. thanks

javanna Over a year ago

Have you tried what was suggested in the answer? It looks good given your requirements...just use a terms query (supports multiple values) instead of a field query.

Collectives™ on Stack Overflow

How to do search on elasticsearch using java api with a list as parameter

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related