Why is this simple numerical operation not precise... - Databricks Community - 33334

Register to join the community

Data Engineering

Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.

I was experimenting with beginner tutorial and saw this strange output ...

Why is this so ? And why is the behavior not consistent for ALL rows updated by the same statement?

8.8 - 1 = 7.800000000000001

See screenshot ...

20220827_180902_msedge_DE_2.1_-_Managing_Delta_Tables_-_Databricks_-_Pers

49 KB

0 REPLIES 0

li.media.uploader-dialog.title

li.media.uploader-dialog.tabs.upload li.media.uploader-dialog.tabs.upload
li.media.uploader-dialog.tabs.web li.media.uploader-dialog.tabs.web
li.media.uploader-dialog.tabs.saved li.media.uploader-dialog.tabs.saved

li.media.album-selector.label

li.media.album-selector.label

li.media.album-selector.title

li.media.album-selector.new.title

li.media.image-upload.drag

li.media.image-upload.drop

li.media.image-upload.mobile.instruction

li.media.image-upload.no-flash

You must be signed in to add attachments

never-displayed

Announcements

Virtual Learning Festival: 9 April - 30 April

Intelligent Data Warehousing: AI/BI for Self-service Analytics

Get Started With Lakehouse Architecture | Pass a quiz to earn your certificate completion.

Data + AI Summit 2025 — registration now open!

Databricks Community Champion - March 2025 - Takuya Omi

upload