Hi

Is decimal or numeric data type also supported?
Input, CSV file:

ID:int,AMOUNT1:float,AMOUNT2:float,AMOUNT3:float
008, 10.05, 15.45, 89.99
100, 20.05, 25.05, 45.05
200, 34.05, 25.05, 75.05

select ID, AMOUNT1+AMOUNT2+AMOUNT3 as TOTAL from CSV.A where ID=100

result:
ID      TOTAL
100  90.149994

Double and Float types are not precise.
Any way to use Decimal type?

Thanks
toivo

Reply via email to