Precision of decimal changed after upload

[beecher92099]

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?

[former_member586390]

Hi,

Dynamically handling decimal precision can be possible via SQL scripts to my knowledge.

I suggest load the actual values from CSV 'as-is' and have one more calculated column in your modeling and handle the precision using conditions. Then populate this cal.column for your reporting.

Hope this helps.

Let me know if you need any more info on this.

Thanks

Regards,

Subramaniyan Ganesan