# Display more than 10k records in sense plugin and elasticsearch-sql plugin

**URL:** <https://discuss.elastic.co/t/display-more-than-10k-records-in-sense-plugin-and-elasticsearch-sql-plugin/140670>\
**Category:** Elasticsearch\
**Created:** [July 19, 2018, 7:20am UTC](https://discuss.elastic.co/t/display-more-than-10k-records-in-sense-plugin-and-elasticsearch-sql-plugin/140670 "2018-07-19T07:20:13Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![sistla](https://avatars.discourse-cdn.com/v4/letter/s/c2a13f/32.png) [@sistla](https://discuss.elastic.co/u/sistla)\
**Post date:** [July 19, 2018, 7:20am UTC](https://discuss.elastic.co/t/display-more-than-10k-records-in-sense-plugin-and-elasticsearch-sql-plugin/140670/1 "2018-07-19T07:20:13Z")

</div>

Hi,

We are using Elasticsearch 2.4.6 , logstash 2.2 and kibana 4.1.6 and installed two plugins to query in the elastic search . But we are able to display only 10,000 records among the existing 1 million records .

Here is our code ,

GET /good/\_search?size=10000  
{  
"query" : {  
"bool":{  
"must":[  
{"match": { "Drop\_EccbTmoRrcConnReEstb": "4" }}  
]  
}  
}  
}

---

<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:** [July 19, 2018, 9:27pm UTC](https://discuss.elastic.co/t/display-more-than-10k-records-in-sense-plugin-and-elasticsearch-sql-plugin/140670/2 "2018-07-19T21:27:28Z")

</div>

Elasticsearch limits by default the number of records you can get back from a search request to 10000.  
If you want more than that, call the `scroll` API or look at the `search_after` feature.

---

<div class="post-metadata">

**Author:** ![sistla](https://avatars.discourse-cdn.com/v4/letter/s/c2a13f/32.png) [@sistla](https://discuss.elastic.co/u/sistla)\
**Post date:** [July 20, 2018, 5:52am UTC](https://discuss.elastic.co/t/display-more-than-10k-records-in-sense-plugin-and-elasticsearch-sql-plugin/140670/3 "2018-07-20T05:52:23Z")

</div>

We tried scroll API and search after feature , but its not showing more than 10k records . Please let us know what to do

Our code :

GET /good/\_search?scroll=1m  
{  
"query" : {  
"term" : { "eCSFB\_to\_CDMA1XRTT\_Exe\_Succ\_Count" : 24 }  
},  
"filter":{  
"and" : [  
{  
"term" : { "eCSFB\_to\_CDMA1XRTT\_Prep\_Succ\_Count" : 24 }  
}

```
        ]
   }

```

}

---

<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:** [July 20, 2018, 6:05am UTC](https://discuss.elastic.co/t/display-more-than-10k-records-in-sense-plugin-and-elasticsearch-sql-plugin/140670/4 "2018-07-20T06:05:02Z")

</div>

What is happening when you call the scroll API with the scroll ID that was given to you after the first call?

---

<div class="post-metadata">

**Author:** ![sistla](https://avatars.discourse-cdn.com/v4/letter/s/c2a13f/32.png) [@sistla](https://discuss.elastic.co/u/sistla)\
**Post date:** [July 20, 2018, 6:35am UTC](https://discuss.elastic.co/t/display-more-than-10k-records-in-sense-plugin-and-elasticsearch-sql-plugin/140670/5 "2018-07-20T06:35:15Z")

</div>

code:

GET /good/\_search?scroll  
{  
"scroll" : "1m",  
"\_scroll\_id": "cXVlcnlUaGVuRmV0Y2g7NTsyNDM5MTk6WE1pZml1N2RSaXU1Q2V3cU1aMF90ZzsyNDM5MjE6WE1pZml1N2RSaXU1Q2V3cU1aMF90ZzsyNDM5MjA6WE1pZml1N2RSaXU1Q2V3cU1aMF90ZzsyNDM5MjI6WE1pZml1N2RSaXU1Q2V3cU1aMF90ZzsyNDM5MjM6WE1pZml1N2RSaXU1Q2V3cU1aMF90ZzswOw==",  
"query" : {  
"term" : { "eCSFB\_to\_CDMA1XRTT\_Exe\_Succ\_Count" : 24 }  
},  
"filter":{  
"and" : [  
{  
"term" : { "eCSFB\_to\_CDMA1XRTT\_Prep\_Succ\_Count" : 24 }  
}

```
        ]
   }

```

}

output:  
{  
"error": {  
"root\_cause": [  
{  
"type": "parse\_exception",  
"reason": "Failed to parse setting [scroll] with value [] as a time value: unit is missing or unrecognized"  
}  
],  
"type": "parse\_exception",  
"reason": "Failed to parse setting [scroll] with value [] as a time value: unit is missing or unrecognized"  
},  
"status": 400  
}

---

<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:** [July 20, 2018, 6:48am UTC](https://discuss.elastic.co/t/display-more-than-10k-records-in-sense-plugin-and-elasticsearch-sql-plugin/140670/6 "2018-07-20T06:48:06Z")

</div>

Scroll API does not work as you posted. See [https://www.elastic.co/guide/en/elasticsearch/reference/6.3/search-request-scroll.html](https://www.elastic.co/guide/en/elasticsearch/reference/6.3/search-request-scroll.html)

Second call should be

```auto
POST /_search/scroll 
{
    "scroll" : "1m", 
    "scroll_id" : "cXVlcnlUaGVuRmV0Y2g7NTsyNDM5MTk6WE1pZml1N2RSaXU1Q2V3cU1aMF90ZzsyNDM5MjE6WE1pZml1N2RSaXU1Q2V3cU1aMF90ZzsyNDM5MjA6WE1pZml1N2RSaXU1Q2V3cU1aMF90ZzsyNDM5MjI6WE1pZml1N2RSaXU1Q2V3cU1aMF90ZzsyNDM5MjM6WE1pZml1N2RSaXU1Q2V3cU1aMF90ZzswOw==" 
}

```

---

<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:** [August 17, 2018, 6:48am UTC](https://discuss.elastic.co/t/display-more-than-10k-records-in-sense-plugin-and-elasticsearch-sql-plugin/140670/7 "2018-08-17T06:48:33Z")

</div>

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