# Is it possible to integrate SQL query into ElasticSearch Java API

**URL:** <https://discuss.elastic.co/t/is-it-possible-to-integrate-sql-query-into-elasticsearch-java-api/179063>\
**Category:** Elasticsearch\
**Created:** [April 30, 2019, 10:26am UTC](https://discuss.elastic.co/t/is-it-possible-to-integrate-sql-query-into-elasticsearch-java-api/179063 "2019-04-30T10:26:03Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Barun\_Kumar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/barun_kumar/32/45308_2.png) [@Barun\_Kumar](https://discuss.elastic.co/u/Barun_Kumar)\
**Post date:** [April 30, 2019, 10:26am UTC](https://discuss.elastic.co/t/is-it-possible-to-integrate-sql-query-into-elasticsearch-java-api/179063/1 "2019-04-30T10:26:03Z")

</div>

I have to search some data using JAVA API. I can do the same using X\_PACK Sql query. Same needs to be done through JAVA API. I have searched a lot but didn't find the reult.  
My Sql Query is like:  
`select map.serviceName as name, count(map.serviceName) as noOfTimesApiUsed, avg(map.executionTimeInSeconds) as averageTime from auditlogs where map.orgId = 'XXXXX' group by map.serviceName order by noOfTimesApiUsed desc`

Please help to change the query in JAVA code.

---

<div class="post-metadata">

**Author:** ![Andrei\_Stefan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrei_stefan/32/47533_2.png) [@Andrei\_Stefan](https://discuss.elastic.co/u/Andrei_Stefan)\
**Post date:** [May 2, 2019, 12:29pm UTC](https://discuss.elastic.co/t/is-it-possible-to-integrate-sql-query-into-elasticsearch-java-api/179063/2 "2019-05-02T12:29:04Z")

</div>

Hi @Barun_Kumar,  
There is the option of the Elasticsearch JDBC driver that you can find more info about [here](https://www.elastic.co/guide/en/elasticsearch/reference/7.x/sql-jdbc.html).

---

<div class="post-metadata">

**Author:** ![Barun\_Kumar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/barun_kumar/32/45308_2.png) [@Barun\_Kumar](https://discuss.elastic.co/u/Barun_Kumar)\
**Post date:** [May 15, 2019, 9:37am UTC](https://discuss.elastic.co/t/is-it-possible-to-integrate-sql-query-into-elasticsearch-java-api/179063/3 "2019-05-15T09:37:33Z")

</div>

this is somehow license related and can be done in Platinum licensed version only. Is it?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [May 15, 2019, 10:11am UTC](https://discuss.elastic.co/t/is-it-possible-to-integrate-sql-query-into-elasticsearch-java-api/179063/4 "2019-05-15T10:11:12Z")

</div>

Correct. You need to activate the trial or enter a platinum license number. You can activate a free trial of the commercial features via Kibana (Management -\> License) or via [the API](https://www.elastic.co/guide/en/elastic-stack-overview/6.3/license-management.html).

See [Subscriptions](https://www.elastic.co/subscriptions) about the different features available.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 12, 2019, 10:11am UTC](https://discuss.elastic.co/t/is-it-possible-to-integrate-sql-query-into-elasticsearch-java-api/179063/5 "2019-06-12T10:11:18Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.