Searching multiple strings in all fields in Elasticsearch using Java API

Question

I've an elasticsearch index having users with fields like.. "name" : "kai" "age" : "23" "location" : "Delhi, India" "tag": [ "search", "nosql" ] etc.

I want to query multiple strings in all fields of user (Eg. ["nosql","delhi"]). Is it possible using Java API?

Here is a sample of code I am using. (But it is irrelevant to the question) Its just to know the objects I am using right now.

BoolQueryBuilder queryBuilder = QueryBuilders.boolQuery()
                .must(QueryBuilders.matchAllQuery());
        if(location!=null) {
            queryBuilder.must(QueryBuilders.matchQuery("location",location));
        }
        BoolFilterBuilder filerBuilder=FilterBuilders.boolFilter();     
        for(String skill:skills){
            filerBuilder.must(FilterBuilders.rangeFilter("tags."+skill).from(0));
        }
        filerBuilder.must(FilterBuilders.queryFilter(queryBuilder));
        if(age!=null) {
            filerBuilder.must(FilterBuilders.rangeFilter("age").from(age[0]).to(age[1]));
        }
        SearchResponse response = client.prepareSearch("skillbin")
                .setTypes("stackdump")
                .setSearchType(SearchType.QUERY_AND_FETCH)
                .setQuery(queryBuilder)   
                .setPostFilter(filerBuilder)
                .addSort("reputation", SortOrder.DESC)
                .execute()
                .actionGet();
        SearchHits hits=response.getHits();

Thanks in advance. :)

Community · Accepted Answer · 2020-06-20 09:12:55Z

8

In Java API, you can query against "_all" field, which by default include all the fields of a document. An alternative way is use MultiMatchQuery which is more flexible and allows you to specify a list of fields you want to query against.

Here is some sample code on how to access "_all" field as well as how to create a MultiMatchQuery by using MultiMatchQueryBuilder and QueryBuilders.multiMatchQuery along a query to search in all the fields:

String queryString = "nosql delhi";

String allField = "_all";

MultiMatchQueryBuilder mmqb = QueryBuilders.multiMatchQuery(queryString, allField);

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jan 14, 2015 at 20:55

hexabunny

1,4151 gold badge11 silver badges12 bronze badges

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

Comments

Natzy8 · Accepted Answer · 2014-12-31 10:43:28Z

1

If you're using standard analyzer, elasticsearch tokenizes every word by default using white space tokenizer.

You can use query string query for your search in that case, where you can add multiple fields to search in. Also query string query's default operator is "OR". So if your search term is "nosql delhi" (as in your case), it is translated into "nosql OR delhi" and searched in all the fields specified in the query. This way you can search multiple terms in multiple fields.

Hope that helps.

answered Dec 31, 2014 at 10:43

Natzy8

153 bronze badges

Comments

Salil Kumar · Accepted Answer · 2020-12-14 08:40:20Z

0

For Java Elastic restHighLevelClient :

replace "_all" with "*".

String queryString = "nosql delhi";

String allField = "*";

MultiMatchQueryBuilder mmqb = QueryBuilders.multiMatchQuery(queryString, allField);

answered Dec 14, 2020 at 8:40

Salil Kumar

1

Collectives™ on Stack Overflow

Searching multiple strings in all fields in Elasticsearch using Java API

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related