# I have written a query in oracle. i want to convert this query in elastic search
**URL:** https://discuss.elastic.co/t/i-have-written-a-query-in-oracle-i-want-to-convert-this-query-in-elastic-search/46171
**Category:** Elasticsearch
**Created:** [April 3, 2016, 2:46pm UTC](https://discuss.elastic.co/t/i-have-written-a-query-in-oracle-i-want-to-convert-this-query-in-elastic-search/46171 "2016-04-03T14:46:40Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@furqan](https://discuss.elastic.co/u/furqan)
#### Post date: [April 3, 2016, 2:46pm UTC](https://discuss.elastic.co/t/i-have-written-a-query-in-oracle-i-want-to-convert-this-query-in-elastic-search/46171/1 "2016-04-03T14:46:40Z")
Below is the query i have written in Oracle i need to write same in Elastic search.
select sum(total\_count),datasource from
(select distinct faspdf\_os\_id,FASPDF\_CUST\_ID,FASPDF\_PROD\_ID,FASPDF\_TIME\_ID,total\_count,datasource from fas\_final\_denom) group by datasource;
Please provide me the solution for this. I need this urgently
Any input will be really appreciated
Thanks
Md Furqan
---
### Author:  [@JoarSvensson](https://discuss.elastic.co/u/JoarSvensson)
#### Post date: [April 4, 2016, 10:36am UTC](https://discuss.elastic.co/t/i-have-written-a-query-in-oracle-i-want-to-convert-this-query-in-elastic-search/46171/2 "2016-04-04T10:36:30Z")
Have a look at: [https://github.com/NLPchina/elasticsearch-sql](https://github.com/NLPchina/elasticsearch-sql) and you should be able to figure it out.
---
### Author:  [@furqan](https://discuss.elastic.co/u/furqan)
#### Post date: [April 4, 2016, 11:48am UTC](https://discuss.elastic.co/t/i-have-written-a-query-in-oracle-i-want-to-convert-this-query-in-elastic-search/46171/3 "2016-04-04T11:48:39Z")
Hi
I looked into your link but it is different than what i am expecting.
This is plugin which uses sql as input instead of json.
But what i want the how to convert that sql query in elastic search query
The same query i want to generate in elastic search
Thanks
Md Furqan
---
### Author:  [@JoarSvensson](https://discuss.elastic.co/u/JoarSvensson)
#### Post date: [April 5, 2016, 12:56pm UTC](https://discuss.elastic.co/t/i-have-written-a-query-in-oracle-i-want-to-convert-this-query-in-elastic-search/46171/4 "2016-04-05T12:56:45Z")
Well if you install the plugin, there's an option to "show JSON query" which will give you the equivalent ES query syntax from the specified SQL syntax.
---
### Author:  [@furqan](https://discuss.elastic.co/u/furqan)
#### Post date: [April 5, 2016, 2:02pm UTC](https://discuss.elastic.co/t/i-have-written-a-query-in-oracle-i-want-to-convert-this-query-in-elastic-search/46171/5 "2016-04-05T14:02:54Z")
Hi
Thanks for replying back.
As per my understanding i need to install the plugin in elastic search using plugin install command.
But i will get the option to generate the json query for the sql.
What is the command for that and how to run it
Thanks
---
### Author:  [@furqan](https://discuss.elastic.co/u/furqan)
#### Post date: [April 5, 2016, 2:06pm UTC](https://discuss.elastic.co/t/i-have-written-a-query-in-oracle-i-want-to-convert-this-query-in-elastic-search/46171/6 "2016-04-05T14:06:17Z")
I have just started learning Elastic search and randomly i get this as a requirement
I need this in urgent basis if you can help me in this then it will be really appreciated.
---
### Author:  [@JoarSvensson](https://discuss.elastic.co/u/JoarSvensson)
#### Post date: [April 12, 2016, 5:43am UTC](https://discuss.elastic.co/t/i-have-written-a-query-in-oracle-i-want-to-convert-this-query-in-elastic-search/46171/7 "2016-04-12T05:43:50Z")
It's all in the documentation: [https://github.com/NLPchina/elasticsearch-sql](https://github.com/NLPchina/elasticsearch-sql)
For ES 2.3: ./bin/plugin install [https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.0.0/elasticsearch-sql-2.3.0.0.zip](https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.0.0/elasticsearch-sql-2.3.0.0.zip)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 5, 2017, 11:00pm UTC](https://discuss.elastic.co/t/i-have-written-a-query-in-oracle-i-want-to-convert-this-query-in-elastic-search/46171/8 "2017-07-05T23:00:26Z")