building kibana query in java to fetch records from elasticsearch

Question

Am fetching records from elasticsearch from java code, am able to fetch records with the elasticsearch _id. For that am using the below java code.

    SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
    MatchQueryBuilder matchQueryBuilder = new MatchQueryBuilder("_id", id); 
    searchSourceBuilder.query(matchQueryBuilder); 
    searchRequest.source(searchSourceBuilder);

From Kibana am using the below query to fetch records from elasticsearch,

GET /_search
{
    "query": {
        "query_string" : {
            "default_field" : "*",
            "query" : "M*"
        }
    }
}

Now, i want to build this query in java., Am not sure how i can build this query in java.

Before anything else you are suggesting to use GET with a message body. Before investing more time, read this first stackoverflow.com/questions/978061/http-get-with-request-body — Oleg Sklyar
– Oleg Sklyar, Commented May 25, 2018 at 7:04
Beyond the above, the body is a JSON structure. So you need some mechanism of constructing a JSON string (manually or serializing a matching DTO) and a library providing an HTTP client to make a request (Java standard library, httpclient from Apache, vert.x etc). Finally, the task has really nothing to do with kibana: you are querying elastic no matter if your request copies the one from Kibana — Oleg Sklyar
– Oleg Sklyar, Commented May 25, 2018 at 7:06

Val · Accepted Answer · 2018-05-25 07:11:52Z

1

You can do it like this:

SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
QueryStringQueryBuilder qsQueryBuilder = new QueryStringQueryBuilder("M*"); 
qsQueryBuilder.defaultField("*");
searchSourceBuilder.query(qsQueryBuilder); 
searchRequest.source(searchSourceBuilder);

answered May 25, 2018 at 7:11

Val

218k14 gold badges377 silver badges384 bronze badges

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

1 Comment

Karthikeyan Over a year ago

Thanks a lot again.. :)

Collectives™ on Stack Overflow

building kibana query in java to fetch records from elasticsearch

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related