enum CsvFieldType does not include a decimal or numeric type right now. Feel free to log a JIRA case. A workaround might be to keep the data as strings then cast explicitly to decimal.
> On May 6, 2016, at 11:14 AM, Toivo Adams <[email protected]> wrote: > > 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
