-
Notifications
You must be signed in to change notification settings - Fork 653
Description
First of all, thanks for an excellent library!
This issue relates to the table column type detection. My use-case is having TableSaw detect the column types of a CSV data file. That information is used to create a table in AWS Redshift and later ingest the CSV file into the table. I am mapping TableSaw INTEGER
column type to Redshift INTEGER
data type.
I came across a corner case in which TableSaw detects numbers ending with ".0", such as "1613.0" or "962.0", as integer column type. This is arguably correct, but fails in my use-case, as AWS Redshift does not accept such values as integers and fails during data load.
Would this case be worthy of a configurable read option, to control whether numbers with zero value decimals will be mapped to integer or floating point types?
ReadOptions.zeroDecimalNumberAsFloat
or a more succinct name would be great.
Tablesaw version 0.37.3.