How to construct QueryBuilder from JSON DSL when using Java API in ElasticSearch?

Question

I'm using ElasticSearch as a search service in Spring Web project which using Transport Client to communicate with ES.

I'm wondering if there exists a method which can construct a QueryBuilder from a JSON DSL. for example, convert this bool query DSL JSON to a QueryBuilder.

{
    "query" : {
        "bool" : {
            "must" : { "match" : {"content" : "quick"},
            "should": { "match": {"content" : "lazy"}
        }
    }
}

I need this method because I have to receive user's bool string input from web front-side, and parse this bool string to a QueryBuilder. However it not suit to use QueryBuilders.boolQuery().must(matchQB).should(shouldQB).must_not(mustNotQB). Because we may need several must or non must query.

If there exist a method can construct a QueryBuilder from JSON DSL or there exists alternative solutions, it will much easier.

PS: I have found two method which can wrap a DSL String to a QueryBuilder for ES search. One is WrapperQueryBuilder, see details here. http://javadoc.kyubu.de/elasticsearch/HEAD/org/elasticsearch/index/query/WrapperQueryBuilder.html Another is QueryBuilders.wrapperQuery(String DSL).

bradvido · Accepted Answer · 2015-01-14 20:38:58Z

37

You can use QueryBuilders.wrapperQuery(jsonQueryString);

answered Jan 14, 2015 at 20:38

bradvido

2,8717 gold badges34 silver badges49 bronze badges

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

1 Comment

Kaliappan Over a year ago

By omitting the {"query":} part in json string works charm !

halfelf · Accepted Answer · 2014-09-16 03:23:27Z

11

You can use setQuery, which can receive a json format string.

/**
 * Constructs a new search source builder with a raw search query.
 */
public SearchRequestBuilder setQuery(String query) {
    sourceBuilder().query(query);
    return this;
}

Note this: only part of the DSL is needed, the {"query": } part is omitted, like this:

SearchResponse searchResponse = client.prepareSearch(indices).setQuery("{\"term\": {\"id\": 1}}").execute().actionGet();

answered Sep 16, 2014 at 3:23

halfelf

10.2k13 gold badges60 silver badges69 bronze badges

4 Comments

Armstrongya Over a year ago

Thanks for your answer, I have found two method in ES API which can wrap DSL string to QueryBuilder, one is WrapperQueryBuilder, another is QueryBuilders.wrapperQuery()

Armstrongya Over a year ago

omit the {"query":} part helps me a lot, thanks again for your help.

Gordon Thompson Over a year ago

For those of you using ES 5.0, this no longer works: discuss.elastic.co/t/…

Felipe Plazas Over a year ago

@GordonThompson exactly, for those using newer versions make sure to check the WrapperQuery.

Sash · Accepted Answer · 2019-06-25 14:35:16Z

1

It might be worth investigating low level rest client. With this you can do:

RestClient esClient = RestClient.builder(new HttpHost("localhost", 9200, "http")).build();
Request request = new Request("POST", "/INDEX_NAME/_doc/_search");
request.setJsonEntity(yourJsonQueryString);

Response response = esClient.performRequest(request);

String jsonResponse = EntityUtils.toString(response.getEntity());

answered Jun 25, 2019 at 14:35

Sash

4,6381 gold badge19 silver badges31 bronze badges

Comments

Amir Berlin · Accepted Answer · 2023-05-28 10:59:57Z

0

With RestHighLevelClient (that uses lowLevelClient())

`Request request = new Request("POST", "yourURL");
    request.setJsonEntity(yourJsonDSL);
    try {
        Response response = restHighLevelClient.getLowLevelClient().performRequest(request);
        String jsonResponse = EntityUtils.toString(response.getEntity());
        JSONObject jsonTransactionObject = new JSONObject(jsonResponse);
    } catch (IOException ex) {
                //error;
    }`

answered May 28, 2023 at 10:59

Amir Berlin

11 bronze badge

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Wojciech Wirzbicki · Accepted Answer · 2024-04-11 08:34:33Z

0

For query (btw. original query contains errors, missing closing braces)

{
    "query" : {
        "bool" : {
            "must" : { "match" : {"content" : "quick"}},
            "should": { "match": {"content" : "lazy"}}
        }
    }
}

the solution is like below, you simply pass the value of "query" node from JSON

QueryBuilders.wrapperQuery("""
    {
        "bool" : {
            "must" : { 
                "match" : {"content" : "quick"}},
            "should": { 
                "match": {"content" : "lazy"}
            }
        }
    }
    """);

answered Apr 11, 2024 at 8:34

Wojciech Wirzbicki

4,4627 gold badges41 silver badges65 bronze badges

Collectives™ on Stack Overflow

How to construct QueryBuilder from JSON DSL when using Java API in ElasticSearch?

5 Answers 5

1 Comment

4 Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

4 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related