How can I query data with BoolQueryBuilder from elasticsearch?

Question

I need to query some data from aws elasticsearch with some condition.

I use the BoolQueryBuilder

And the params is about pretty=true

here is my code:

SearchSourceBuilder sourceBuilder = new SearchSourceBuilder();
BoolQueryBuilder boolQueryBuilder = new BoolQueryBuilder();
QueryBuilder qb1 = QueryBuilders.matchQuery("personId", personId);
boolQueryBuilder.must(qb1);
sourceBuilder.query(boolQueryBuilder);
result = searchUtil.getResult(params, sourceBuilder);

the following is the error message

{
  "error" : {
    "root_cause" : [
      {
        "type" : "parsing_exception",
        "reason" : "Unknown key for a START_OBJECT in [queryBuilder].",
        "line" : 1,
        "col" : 17
      }
    ],
    "type" : "parsing_exception",
    "reason" : "Unknown key for a START_OBJECT in [queryBuilder].",
    "line" : 1,
    "col" : 17
  },
  "status" : 400
}

can anyone help?! please!

searchUtil.getResult is your own method ?

Amit
– Amit

2019-12-17 10:41:30 +00:00
Commented Dec 17, 2019 at 10:41 — Amit
– Amit, Commented Dec 17, 2019 at 10:41

Amit · Accepted Answer · 2019-12-17 11:27:53Z

2

Not sure what is the use of result = searchUtil.getResult(params, sourceBuilder); in your code.

You can read this official ES doc for constructing the queries using the query builders which you are using also refer this official ES example to construct your query.

It's very simple and my guess the reason for your error is(As complete information isn't available) that you are using some other utility to get the result which is unable to process your JSON.

Edit: Added code that worked locally for me using java high-level rest-client version 7.4 of Elasticsearch.

    SearchSourceBuilder sourceBuilder = new SearchSourceBuilder();
    BoolQueryBuilder boolQueryBuilder = new BoolQueryBuilder();
    QueryBuilder qb1 = QueryBuilders.matchQuery("personId", "kimchy");
    boolQueryBuilder.must(qb1);
    sourceBuilder.query(boolQueryBuilder);
    //String searchJson = sourceBuilder.toString(); // if you want to print search json for debugging
    SearchRequest searchRequest = new SearchRequest(indexName);// your index name
    searchRequest.source(sourceBuilder);
    SearchResponse searchResponse = client.search(searchRequest, RequestOptions.DEFAULT);

Please note last three lines of code are very important which is missing in your code and these are used to create a search request using query and actually firing this search request using the ES client and getting the result.

edited Dec 17, 2019 at 11:27

answered Dec 17, 2019 at 11:20

Amit

32.5k7 gold badges68 silver badges101 bronze badges

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

4 Comments

蘇柏綸 Over a year ago

Hi! i try your code and it works! By the way, the response is all bytes, how can i transform to text?!

蘇柏綸 Over a year ago

i saw the document and solved the problem thank you so much !!

蘇柏綸 Over a year ago

I ’m not really sure how to use it. is that accept and vote now?

Ilya Lisov Over a year ago

It is deprecated now

Collectives™ on Stack Overflow

How can I query data with BoolQueryBuilder from elasticsearch?

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