# Reflection creation failed 'Unknown type: DECIMAL'

**URL:** <https://community.dremio.com/t/reflection-creation-failed-unknown-type-decimal/1973>\
**Category:** Uncategorized\
**Created:** [October 4, 2018, 7:59pm UTC](https://community.dremio.com/t/reflection-creation-failed-unknown-type-decimal/1973 "2018-10-04T19:59:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Monika\_Goel](https://avatars.discourse-cdn.com/v4/letter/m/258eb7/32.png) [@Monika\_Goel](https://community.dremio.com/u/Monika_Goel)\
**Post date:** [October 4, 2018, 7:59pm UTC](https://community.dremio.com/t/reflection-creation-failed-unknown-type-decimal/1973/1 "2018-10-04T19:59:01Z")

</div>

Hi Team.

I am trying to create a Raw Reflection using partition by & sort field. But it fails with ‘UnsupportedOperationException: Unknown type: DECIMAL’ error, while ‘planner.enable\_decimal\_data\_type’ is set in advance settings. Job profile attached for your reference. Please suggest how to overcome this error.

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

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

[a89ec84d-3f82-4990-86da-b193ad02c476.zip](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/1X/b28f404db642fae1cf2e8859a91aab4544f4330d.zip) (74.7 KB)

Thanks.

---

<div class="post-metadata">

**Author:** ![Monika\_Goel](https://avatars.discourse-cdn.com/v4/letter/m/258eb7/32.png) [@Monika\_Goel](https://community.dremio.com/u/Monika_Goel)\
**Post date:** [October 5, 2018, 1:18pm UTC](https://community.dremio.com/t/reflection-creation-failed-unknown-type-decimal/1973/2 "2018-10-05T13:18:12Z")

</div>

@anthony Any insight please. Tried by resetting ‘planner.enable\_decimal\_data\_type’ value and restarting dremio. But same results.