# Divide Data and fire query in elasticsearch
**URL:** https://discuss.elastic.co/t/divide-data-and-fire-query-in-elasticsearch/116231
**Category:** Elasticsearch
**Created:** [January 19, 2018, 12:39pm UTC](https://discuss.elastic.co/t/divide-data-and-fire-query-in-elasticsearch/116231 "2018-01-19T12:39:22Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Devanshu\_Sharma](https://discuss.elastic.co/u/Devanshu_Sharma)
#### Post date: [January 19, 2018, 12:39pm UTC](https://discuss.elastic.co/t/divide-data-and-fire-query-in-elasticsearch/116231/1 "2018-01-19T12:39:22Z")
HI,
I have to two index name is index1 or index2.
Both one index1 or index2 have 1000000(10 lac.) data.
I want to divide 100000(1 lac.) any one index data and apply query index1 column1 or index2 column2 both to merged and get inner join data.
query = "select \* from index1 t1 inner join index2 t2 where t1.column1=t2.column2";
how can get data first time apply 1 lac. data(0-100000) then another 1lac.(100001-200000) similler to 10lac.
can you help me what can i do and please give me solution java lang.?
SearchDao searchDao = new SearchDao(esClient);
SqlElasticRequestBuilder explain = searchDao.explain(query).explain();
ElasticJoinExecutor executor = ElasticJoinExecutor.createJoinExecutor(searchDao.getClient(),explain);
executor.run();
SearchHits hits = executor.getHits();
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [January 22, 2018, 10:06am UTC](https://discuss.elastic.co/t/divide-data-and-fire-query-in-elasticsearch/116231/2 "2018-01-22T10:06:18Z")
Please format your code using `` icon as explained in [this guide](https://discuss.elastic.co/t/about-the-elasticsearch-category/21). It will make your post more readable.
Or use markdown style like:
````
```
CODE
```
````
It might be better to ask the author of this plugin: [https://github.com/NLPchina/elasticsearch-sql](https://github.com/NLPchina/elasticsearch-sql) (sounds like you are using that).
Note that JOINS are not supported in elasticsearch.
---
### Author:  [@Devanshu\_Sharma](https://discuss.elastic.co/u/Devanshu_Sharma)
#### Post date: [January 22, 2018, 12:34pm UTC](https://discuss.elastic.co/t/divide-data-and-fire-query-in-elasticsearch/116231/3 "2018-01-22T12:34:09Z")
> [@dadoonet](#):
>
> that JOINS are not supported in elasticsearch.
I can use Joins in elasticsearch
query = "SELECT t0._,t1._ FROM 265191429v5 t0 INNER JOIN 265191429v3 t1 ON ([t0.order\_id] = [t1.order\_id])"
_ **code** _\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*
SearchDao searchDao = new SearchDao(esClient);
SqlElasticRequestBuilder explain = searchDao.explain(query).explain();
ElasticJoinExecutor executor = ElasticJoinExecutor.createJoinExecutor(searchDao.getClient(), explain);
executor.run();
SearchHits hits = executor.getHits();
* * *
But i got only 1 lac data. I want all data using inner join.
can you tell me...
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [January 22, 2018, 12:53pm UTC](https://discuss.elastic.co/t/divide-data-and-fire-query-in-elasticsearch/116231/4 "2018-01-22T12:53:39Z")
Please format your code.
> > that JOINS are not supported in elasticsearch.
>
> I can use Joins in elasticsearch
`ElasticJoinExecutor` is not part of elasticsearch. That's what I'm telling you. The only way to do joins **officially** in elasticsearch is by using this: [join datatype | Elasticsearch Reference [6.1] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/6.1/parent-join.html)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 19, 2018, 12:53pm UTC](https://discuss.elastic.co/t/divide-data-and-fire-query-in-elasticsearch/116231/5 "2018-02-19T12:53:56Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.