โ06-08-2023 11:20 PM
I am facing an issue, I have implemented a code in which I am performing sum on decimal values. I have set precision as Decimal(19,2). When I am calculating for big data I am getting different value as I got from my .Net Utility application. ex. From .Net Utility O/P : 19546.45 and in databricks : 19546.46. I am not sure why databricks is changing values automatically? I need to make sync between .Net utility & databricks data. What is default rounding in decimal precision while doing sum in databricks? Can someone help me for this?
โ06-09-2023 12:50 AM
I think it is half_up (so starting from 5 round upwards).
with the round() and bround() function you can control the rounding.
โ06-09-2023 12:50 AM
I think it is half_up (so starting from 5 round upwards).
with the round() and bround() function you can control the rounding.
โ06-13-2023 11:10 PM
Hi @Pragya Sharmaโ
We haven't heard from you since the last response from @Werner Stinckensโ . Kindly share the information with us, and in return, we will provide you with the necessary solution.
Thanks and Regards
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโt want to miss the chance to attend and share knowledge.
If there isnโt a group near you, start one and help create a community that brings people together.
Request a New Group