# Dremio Limits on number of columns in Tables, way to increase it

**URL:** <https://community.dremio.com/t/dremio-limits-on-number-of-columns-in-tables-way-to-increase-it/5597>\
**Category:** Dremio University\
**Created:** [May 21, 2020, 9:34pm UTC](https://community.dremio.com/t/dremio-limits-on-number-of-columns-in-tables-way-to-increase-it/5597 "2020-05-21T21:34:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![gauravpranay](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gauravpranay](https://community.dremio.com/u/gauravpranay)\
**Post date:** [May 21, 2020, 9:34pm UTC](https://community.dremio.com/t/dremio-limits-on-number-of-columns-in-tables-way-to-increase-it/5597/1 "2020-05-21T21:34:23Z")

</div>

As per link : [https://docs.dremio.com/advanced-administration/limits.html](https://docs.dremio.com/advanced-administration/limits.html)  
I see the limits on no of columns is restricted to 800 but we have a requirement to query a table which has 1000+ columns & was wondering if there is any way to increase restrictions.  
Dremio community Version: 4.1.4-202001240912140359-a90eb503  
@balaji.ramaswamy , Any ideas on this issue, will be very helpful. Thanks !

---

<div class="post-metadata">

**Author:** ![Rakesh\_Malugu](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/rakesh_malugu/32/2384_2.png) [@Rakesh\_Malugu](https://community.dremio.com/u/Rakesh_Malugu)\
**Post date:** [May 22, 2020, 12:55pm UTC](https://community.dremio.com/t/dremio-limits-on-number-of-columns-in-tables-way-to-increase-it/5597/2 "2020-05-22T12:55:30Z")

</div>

Hello gauravpranay,

Currently 800 is the limit for number of columns in a table.

And we do not have any parameter to increase this value. This is the current limitation.

Thanks,  
Rakesh

---

<div class="post-metadata">

**Author:** ![gauravpranay](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gauravpranay](https://community.dremio.com/u/gauravpranay)\
**Post date:** [May 22, 2020, 2:31pm UTC](https://community.dremio.com/t/dremio-limits-on-number-of-columns-in-tables-way-to-increase-it/5597/3 "2020-05-22T14:31:42Z")

</div>

Thanks Rakesh, is there any enhancements planned on it for future releases ?

---

<div class="post-metadata">

**Author:** ![Rakesh\_Malugu](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/rakesh_malugu/32/2384_2.png) [@Rakesh\_Malugu](https://community.dremio.com/u/Rakesh_Malugu)\
**Post date:** [May 22, 2020, 2:43pm UTC](https://community.dremio.com/t/dremio-limits-on-number-of-columns-in-tables-way-to-increase-it/5597/4 "2020-05-22T14:43:03Z")

</div>

Hello gauravpranay

Yes, there is an enhancement request is in place, however, right now at the moment we cannot guarantee the version in which it is going to implement.

Thanks,  
Rakesh

---

<div class="post-metadata">

**Author:** ![gauravpranay](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gauravpranay](https://community.dremio.com/u/gauravpranay)\
**Post date:** [May 22, 2020, 3:02pm UTC](https://community.dremio.com/t/dremio-limits-on-number-of-columns-in-tables-way-to-increase-it/5597/5 "2020-05-22T15:02:56Z")

</div>

Thanks Rakesh, will keep looking for future release notes of dremio.