How to write elasticsearch-sql query using Java High-Level REST Client API

Question

This is my Elasticsearch-sql query. I executed this query using Kibana and getting valid output.

GET _sql?format=json { "query": "SELECT Count(appId) FROM eps_stbl_logs where cast(timestamp AS DATE) = TODAY() and status = 'COMPLETED'" }

This needs to be written in restHighLevelClient java API. Could you please help to write java API as I am new to ElasticSearch with Java.

Alexander Raithel · Accepted Answer · 2020-05-15 14:01:07Z

3

It could work like this:

        Request request = new Request("GET", "/_sql");
        request.setJsonEntity("{\"query\":\"SELECT Count(appId) FROM eps_stbl_logs where cast(timestamp AS DATE) = TODAY() and status = 'COMPLETED'\"}");
        Response response = restHighLevelClient.getLowLevelClient().performRequest(request);
        String responseBody = EntityUtils.toString(response.getEntity());

answered May 15, 2020 at 14:01

Alexander Raithel

414 bronze badges

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

4 Comments

HShetty Over a year ago

hank you Alexander :) I will try and get back toy you.

HShetty Over a year ago

Thanks a lot. its working perfectly. I need one more suggestion from you for the below query. How can I add fitter query for existing java code. GET _sql?format=json { "query": "SELECT Count(appId) FROM eps_stbl_logs where status = 'COMPLETED'", "filter": { "range" : { "@timestamp" : { "from" : "10/05/2020", "to" : "13/05/2020", "format" : "dd/MM/yyyy" }}}}

Alexander Raithel Over a year ago

Just add the filter condition: String query = "{\"query\":\"SELECT * FROM eps_stbl_logs\"," + "\"filter\": {" + " \"range\": {" + " \"@timestamp\": {" + " \"from\": \"10/05/2020\"," + " \"to\": \"13/05/2020\"," + " \"format\": \"dd/MM/yyyy\"" + " }" + " }" + "}}";

HShetty Over a year ago

Thanks a Alexander for your quick response. :)

Collectives™ on Stack Overflow

How to write elasticsearch-sql query using Java High-Level REST Client API

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