Skip to Content
1
Aug 02, 2019 at 10:39 PM

Precision of decimal changed after upload

947 Views

I have a CSV file that I'm uploading to a table in HANA. The file includes decimal numbers, so numbers with up 18 digits after the decimal place. I defined the column as DECIMAL(34,18). One problem when a number has fewer digits after the decimal (e.g., 0.3334), the number is showing as 0.3333999999999999741540079867263557 when inspecting the contents of the table. Why is the number not simply showing as it's value in the source csv file?