# MongoDB Decimal128 Support

**URL:** <https://community.dremio.com/t/mongodb-decimal128-support/5697>\
**Category:** Uncategorized\
**Created:** [June 9, 2020, 9:42am UTC](https://community.dremio.com/t/mongodb-decimal128-support/5697 "2020-06-09T09:42:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![RGupta2020](https://avatars.discourse-cdn.com/v4/letter/r/a183cd/32.png) [@RGupta2020](https://community.dremio.com/u/RGupta2020)\
**Post date:** [June 9, 2020, 9:42am UTC](https://community.dremio.com/t/mongodb-decimal128-support/5697/1 "2020-06-09T09:42:47Z")

</div>

Hey I am using Dremio Latest version and Mongo DB 4.0. In collection we are using Decimal128 data type. I successfully connected to my Mongo DB but when I am trying to fetch the data it is showing the following error.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/8/82914d63aa3736b82b275542f644db0c7f207722.png)

Please let me know if you need more information.

---

<div class="post-metadata">

**Author:** ![andreat](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/andreat/32/2311_2.png) [@andreat](https://community.dremio.com/u/andreat)\
**Post date:** [June 9, 2020, 2:39pm UTC](https://community.dremio.com/t/mongodb-decimal128-support/5697/2 "2020-06-09T14:39:52Z")

</div>

Dremio 4.1.8 and older versions use an older version of MongoDB’s JDBC driver, you could try to see if you get the same error with Dremio 4.1.8 or previous versions.

---

<div class="post-metadata">

**Author:** ![RGupta2020](https://avatars.discourse-cdn.com/v4/letter/r/a183cd/32.png) [@RGupta2020](https://community.dremio.com/u/RGupta2020)\
**Post date:** [June 9, 2020, 3:22pm UTC](https://community.dremio.com/t/mongodb-decimal128-support/5697/3 "2020-06-09T15:22:49Z")

</div>

I tried with Dremio 4.1.8 and lower version but still getting the same error.

020-06-09T15:21:02.951+0000: [GC (Allocation Failure) [PSYoungGen: 678910K-\>106983K(695808K)] 841564K-\>275552K(967168K), 0.1526652 secs] [Times: user=0.27 sys=0.01, real=0.15 secs]  
2020-06-09 15:21:09,656 [e0 - 21205726-76af-0233-82f6-c74c6f885300:frag:0:0] ERROR com.dremio.sabot.driver.SmartOp - UnsupportedOperationException  
com.dremio.common.exceptions.UserException: UnsupportedOperationException  
at com.dremio.common.exceptions.UserException$Builder.build(UserException.java:776) ~[dremio-common-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.driver.SmartOp.contextualize(SmartOp.java:140) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.driver.SmartOp$SmartProducer.outputData(SmartOp.java:523) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.driver.StraightPipe.pump(StraightPipe.java:56) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.driver.Pipeline.doPump(Pipeline.java:109) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.driver.Pipeline.pumpOnce(Pipeline.java:99) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.exec.fragment.FragmentExecutor$DoAsPumper.run(FragmentExecutor.java:336) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.exec.fragment.FragmentExecutor.run(FragmentExecutor.java:285) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.exec.fragment.FragmentExecutor.access$1200(FragmentExecutor.java:92) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.exec.fragment.FragmentExecutor$AsyncTaskImpl.run(FragmentExecutor.java:674) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.task.AsyncTaskWrapper.run(AsyncTaskWrapper.java:104) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.task.slicing.SlicingThread.mainExecutionLoop(SlicingThread.java:226) [dremio-ce-sabot-scheduler-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.task.slicing.SlicingThread.run(SlicingThread.java:156) [dremio-ce-sabot-scheduler-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
Caused by: java.lang.UnsupportedOperationException: null  
at java.util.Collections$UnmodifiableMap.put(Collections.java:1459) ~[na:1.8.0\_242]  
at com.dremio.plugins.mongo.execution.BsonRecordReader.writeDecimal(BsonRecordReader.java:336) ~[dremio-ce-mongo-plugin-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.plugins.mongo.execution.BsonRecordReader.writeToListOrMap(BsonRecordReader.java:145) ~[dremio-ce-mongo-plugin-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.plugins.mongo.execution.BsonRecordReader.writeToListOrMap(BsonRecordReader.java:141) ~[dremio-ce-mongo-plugin-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.plugins.mongo.execution.BsonRecordReader.write(BsonRecordReader.java:65) ~[dremio-ce-mongo-plugin-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.plugins.mongo.execution.MongoRecordReader.next(MongoRecordReader.java:251) ~[dremio-ce-mongo-plugin-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.op.scan.ScanOperator.outputData(ScanOperator.java:236) ~[dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.driver.SmartOp$SmartProducer.outputData(SmartOp.java:521) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
… 10 common frames omitted

---

<div class="post-metadata">

**Author:** ![RGupta2020](https://avatars.discourse-cdn.com/v4/letter/r/a183cd/32.png) [@RGupta2020](https://community.dremio.com/u/RGupta2020)\
**Post date:** [June 9, 2020, 3:23pm UTC](https://community.dremio.com/t/mongodb-decimal128-support/5697/4 "2020-06-09T15:23:28Z")

</div>

I tried with Dremio 4.1.8 and lower version but still getting the same error.

020-06-09T15:21:02.951+0000: [GC (Allocation Failure) [PSYoungGen: 678910K-\>106983K(695808K)] 841564K-\>275552K(967168K), 0.1526652 secs] [Times: user=0.27 sys=0.01, real=0.15 secs]  
2020-06-09 15:21:09,656 [e0 - 21205726-76af-0233-82f6-c74c6f885300:frag:0:0] ERROR com.dremio.sabot.driver.SmartOp - UnsupportedOperationException  
com.dremio.common.exceptions.UserException: UnsupportedOperationException  
at com.dremio.common.exceptions.UserException$Builder.build(UserException.java:776) ~[dremio-common-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.driver.SmartOp.contextualize(SmartOp.java:140) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.driver.SmartOp$SmartProducer.outputData(SmartOp.java:523) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.driver.StraightPipe.pump(StraightPipe.java:56) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.driver.Pipeline.doPump(Pipeline.java:109) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.driver.Pipeline.pumpOnce(Pipeline.java:99) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.exec.fragment.FragmentExecutor$DoAsPumper.run(FragmentExecutor.java:336) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.exec.fragment.FragmentExecutor.run(FragmentExecutor.java:285) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.exec.fragment.FragmentExecutor.access$1200(FragmentExecutor.java:92) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.exec.fragment.FragmentExecutor$AsyncTaskImpl.run(FragmentExecutor.java:674) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.task.AsyncTaskWrapper.run(AsyncTaskWrapper.java:104) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.task.slicing.SlicingThread.mainExecutionLoop(SlicingThread.java:226) [dremio-ce-sabot-scheduler-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.task.slicing.SlicingThread.run(SlicingThread.java:156) [dremio-ce-sabot-scheduler-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
Caused by: java.lang.UnsupportedOperationException: null  
at java.util.Collections$UnmodifiableMap.put(Collections.java:1459) ~[na:1.8.0\_242]  
at com.dremio.plugins.mongo.execution.BsonRecordReader.writeDecimal(BsonRecordReader.java:336) ~[dremio-ce-mongo-plugin-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.plugins.mongo.execution.BsonRecordReader.writeToListOrMap(BsonRecordReader.java:145) ~[dremio-ce-mongo-plugin-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.plugins.mongo.execution.BsonRecordReader.writeToListOrMap(BsonRecordReader.java:141) ~[dremio-ce-mongo-plugin-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.plugins.mongo.execution.BsonRecordReader.write(BsonRecordReader.java:65) ~[dremio-ce-mongo-plugin-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.plugins.mongo.execution.MongoRecordReader.next(MongoRecordReader.java:251) ~[dremio-ce-mongo-plugin-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.op.scan.ScanOperator.outputData(ScanOperator.java:236) ~[dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
at com.dremio.sabot.driver.SmartOp$SmartProducer.outputData(SmartOp.java:521) [dremio-sabot-kernel-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]  
… 10 common frames omitted

---

<div class="post-metadata">

**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:** [June 10, 2020, 6:17am UTC](https://community.dremio.com/t/mongodb-decimal128-support/5697/5 "2020-06-10T06:17:28Z")

</div>

@RGupta2020

Currently we only support Mongo 3.x, we are in the process of releasing support for Mongo 4.x

The release notes will have the update when it is available

Thaks  
@balaji.ramaswamy
