# Error while Querying S3 (Parquet / Decimal data type)

**URL:** <https://community.dremio.com/t/error-while-querying-s3-parquet-decimal-data-type/912>\
**Category:** Uncategorized\
**Created:** [March 23, 2018, 6:49pm UTC](https://community.dremio.com/t/error-while-querying-s3-parquet-decimal-data-type/912 "2018-03-23T18:49:52Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![sanjay0423](https://avatars.discourse-cdn.com/v4/letter/s/bc8723/32.png) [@sanjay0423](https://community.dremio.com/u/sanjay0423)\
**Post date:** [March 23, 2018, 6:49pm UTC](https://community.dremio.com/t/error-while-querying-s3-parquet-decimal-data-type/912/1 "2018-03-23T18:49:52Z")

</div>

Using the following -\>

dremio-community-1.4.9-201802191836310213\_7195059\_1.noarch.rpm

Getting the error -\>

Decimal data type is disabled. As of this release decimal data type is a beta level feature and should not be used in production Use option ‘planner.enable\_decimal\_data\_type’ to enable decimal data type

---

<div class="post-metadata">

**Author:** ![laurent](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/laurent/32/16_2.png) [@laurent](https://community.dremio.com/u/laurent)\
**Post date:** [March 23, 2018, 6:53pm UTC](https://community.dremio.com/t/error-while-querying-s3-parquet-decimal-data-type/912/2 "2018-03-23T18:53:40Z")

</div>

It’s exactly as the error message says: decimal support is still not considered production ready, and is disabled by default. You can enable it by going to `Admin` \> `Advanced Settings`, and setting the option `planner.enable_decimal_data_type` to `true`

---

<div class="post-metadata">

**Author:** ![sanjay0423](https://avatars.discourse-cdn.com/v4/letter/s/bc8723/32.png) [@sanjay0423](https://community.dremio.com/u/sanjay0423)\
**Post date:** [March 23, 2018, 6:56pm UTC](https://community.dremio.com/t/error-while-querying-s3-parquet-decimal-data-type/912/3 "2018-03-23T18:56:43Z")

</div>

![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/1X/34565631a68deb08293b2093fd5616ff48373ecc.jpg)

Thanks for the quick reply. Where exactly that setting is ?

---

<div class="post-metadata">

**Author:** ![sanjay0423](https://avatars.discourse-cdn.com/v4/letter/s/bc8723/32.png) [@sanjay0423](https://community.dremio.com/u/sanjay0423)\
**Post date:** [March 23, 2018, 7:00pm UTC](https://community.dremio.com/t/error-while-querying-s3-parquet-decimal-data-type/912/4 "2018-03-23T19:00:09Z")

</div>

Does it come under advanced Support ?

 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/1X/9570dee7001aff101a65a6b07a13ea4f15f0a149.jpg)

---

<div class="post-metadata">

**Author:** ![laurent](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/laurent/32/16_2.png) [@laurent](https://community.dremio.com/u/laurent)\
**Post date:** [March 23, 2018, 7:00pm UTC](https://community.dremio.com/t/error-while-querying-s3-parquet-decimal-data-type/912/5 "2018-03-23T19:00:54Z")

</div>

![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/1X/5299ecdcbaf96a336e4235bf266bd9512a23c8a4.png)

if you scroll at the bottom of the page, you will see a section named `Dremio Support`. Enter the key and click `Show` to have the setting to appear, and then toggle the value.

---

<div class="post-metadata">

**Author:** ![sanjay0423](https://avatars.discourse-cdn.com/v4/letter/s/bc8723/32.png) [@sanjay0423](https://community.dremio.com/u/sanjay0423)\
**Post date:** [March 23, 2018, 8:09pm UTC](https://community.dremio.com/t/error-while-querying-s3-parquet-decimal-data-type/912/6 "2018-03-23T20:09:09Z")

</div>

What is the key for comunity version

---

<div class="post-metadata">

**Author:** ![laurent](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/laurent/32/16_2.png) [@laurent](https://community.dremio.com/u/laurent)\
**Post date:** [March 23, 2018, 8:21pm UTC](https://community.dremio.com/t/error-while-querying-s3-parquet-decimal-data-type/912/7 "2018-03-23T20:21:38Z")

</div>

The key is the setting name given by the error message (or in the screenshot above).

---

<div class="post-metadata">

**Author:** ![sanjay0423](https://avatars.discourse-cdn.com/v4/letter/s/bc8723/32.png) [@sanjay0423](https://community.dremio.com/u/sanjay0423)\
**Post date:** [March 24, 2018, 7:49pm UTC](https://community.dremio.com/t/error-while-querying-s3-parquet-decimal-data-type/912/8 "2018-03-24T19:49:43Z")

</div>

Worked. Thanks much. planner.enable\_decimal\_data\_type