# How to increase download limit over 1 million

**URL:** <https://community.dremio.com/t/how-to-increase-download-limit-over-1-million/3774>\
**Category:** Uncategorized\
**Created:** [July 29, 2019, 2:32pm UTC](https://community.dremio.com/t/how-to-increase-download-limit-over-1-million/3774 "2019-07-29T14:32:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kyle](https://avatars.discourse-cdn.com/v4/letter/k/848f3c/32.png) [@Kyle](https://community.dremio.com/u/Kyle)\
**Post date:** [July 29, 2019, 2:32pm UTC](https://community.dremio.com/t/how-to-increase-download-limit-over-1-million/3774/1 "2019-07-29T14:32:12Z")

</div>

I tried to export over 1 million records of hive as CSV but I am getting “Downloads are limited to one million records”

So I try to alter this options,but it seems to be ineffective

 ![1](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/a/a443da58bc080104ec451fdd5d4b85eaa9f08c7e.jpeg)

Can you help me ?  
Thanks

---

<div class="post-metadata">

**Author:** ![doron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/doron/32/294_2.png) [@doron](https://community.dremio.com/u/doron)\
**Post date:** [July 29, 2019, 6:25pm UTC](https://community.dremio.com/t/how-to-increase-download-limit-over-1-million/3774/2 "2019-07-29T18:25:39Z")

</div>

Hi,

It is currently not configurable. We usually recommend people use ODBC/JDBC to retrieve large results - the other choice is to use our CREATE TABLE AS functionality ([https://www.dremio.com/tutorials/high-performance-parallel-exports/](https://www.dremio.com/tutorials/high-performance-parallel-exports/)).

---

<div class="post-metadata">

**Author:** ![Kyle](https://avatars.discourse-cdn.com/v4/letter/k/848f3c/32.png) [@Kyle](https://community.dremio.com/u/Kyle)\
**Post date:** [July 30, 2019, 6:46am UTC](https://community.dremio.com/t/how-to-increase-download-limit-over-1-million/3774/3 "2019-07-30T06:46:23Z")

</div>

Thank you for your response!