# How to get all data of ElasticSearch to Dremio **URL:** \ **Category:** Uncategorized\ **Created:** [August 10, 2022, 3:20am UTC](https://community.dremio.com/t/how-to-get-all-data-of-elasticsearch-to-dremio/9511 "2022-08-10T03:20:28Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![robocon20x](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/robocon20x/32/4321_2.png) [@robocon20x](https://community.dremio.com/u/robocon20x)\ **Post date:** [August 10, 2022, 3:20am UTC](https://community.dremio.com/t/how-to-get-all-data-of-elasticsearch-to-dremio/9511/1 "2022-08-10T03:20:28Z")
Hi guys, i’m new with Dremio, i connected my standalone Dremio with standalone Es on my computer and it’s only get 10,000 rows of Es (limit of 1 scroll in Es). So how can i config Dremio to get all data from Es? while i founding solution, i saw some people can query on 2M row of Es it mean more than 10,000 limit. but i don’t know how could they do that. Please help me. Thanks a lot. ---
**Author:** ![robocon20x](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/robocon20x/32/4321_2.png) [@robocon20x](https://community.dremio.com/u/robocon20x)\ **Post date:** [August 10, 2022, 4:55am UTC](https://community.dremio.com/t/how-to-get-all-data-of-elasticsearch-to-dremio/9511/2 "2022-08-10T04:55:00Z")
@lenoyjacob @ben , can you help me with this question? ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [August 10, 2022, 5:28am UTC](https://community.dremio.com/t/how-to-get-all-data-of-elasticsearch-to-dremio/9511/3 "2022-08-10T05:28:39Z")
@robocon20x You are probably clicking preview instead of run. The preview will limit to 10K, click run and you can see up to 1 a maximum of million. When queries are run from JDBC or ODBC tools, they are not truncated by Dremio but may get truncated by the JDBC tool, any reason you want to look at more than a million rows? ---
**Author:** ![robocon20x](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/robocon20x/32/4321_2.png) [@robocon20x](https://community.dremio.com/u/robocon20x)\ **Post date:** [August 10, 2022, 5:50am UTC](https://community.dremio.com/t/how-to-get-all-data-of-elasticsearch-to-dremio/9511/4 "2022-08-10T05:50:33Z")
![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/9/9ae4616e6c771dae8b1db8040116859cd4b4641c.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/3/333ba313ca926d47e4762697a17ed3b16f02ad3d.png) @balaji.ramaswamy dear sir, i had click run bottom and use count(_) to count number of rows in the table. i had remove ES and connect it again to Dremio but it still only 10,000 rows. the same result when i use jbdc to execute count(_) query ☹ . Thank sir. In addion: i install Dremio by this way [install](https://gist.github.com/pedrinholula/3ae905d08793b4586b09d3fa3afe55d8) my ES version is 7.12.0 and Dremio is 22.0.0-202206221430090603-1fa4049f ---
**Author:** ![robocon20x](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/robocon20x/32/4321_2.png) [@robocon20x](https://community.dremio.com/u/robocon20x)\ **Post date:** [August 10, 2022, 7:15am UTC](https://community.dremio.com/t/how-to-get-all-data-of-elasticsearch-to-dremio/9511/5 "2022-08-10T07:15:43Z")
@balaji.ramaswamy Dear sir, i found this question and it seem similar with my case. but it still no answer ere [question](https://community.dremio.com/t/dremio-returns-wrong-value-on-simple-count-on-elasticsearch/9260) . Thank you so much ---
**Author:** ![robocon20x](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/robocon20x/32/4321_2.png) [@robocon20x](https://community.dremio.com/u/robocon20x)\ **Post date:** [August 11, 2022, 2:10am UTC](https://community.dremio.com/t/how-to-get-all-data-of-elasticsearch-to-dremio/9511/6 "2022-08-11T02:10:14Z")
@balaji.ramaswamy dear sir, my index have more than 1m docs(rows), how can i handle this sir? thanks