title: How to write elasticsearch-sql query using Java High-Level REST Client API
body: <p>This is my Elasticsearch-sql query. I executed this query using Kibana and getting valid output.</p>
  
  <p>GET _sql?format=json
  {
    "query": "SELECT Count(appId) FROM eps_stbl_logs where cast(timestamp AS DATE) = TODAY() and status = 'COMPLETED'"
    } </p>
  
  <p>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.</p>