cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Help
Data Engineering
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Why is this simple numerical operation not precise?

al_joe
Contributor

‎08-27-2022 05:49 AM

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

Labels:
Preview file
49 KB
0 REPLIES 0
Announcements
Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.