Have some CSV data that Drill 1.5 selects as-is without any problems,
until I attempt to CAST columns in a CTAS or plain SELECT:
Error: SYSTEM ERROR: NumberFormatException: 140.755
The data is unquoted CSV, and column in question does have the value
"140.755" (unquoted). As the column can be empty, I am using the
following transform:
CAST(COALESCE(t_total, 0) AS double) AS t_total
And on the first data row:
Fragment 1:0
[Error Id: 4b4d83cf-a87d-451e-9cfa-4280e5adf64f on es08:31010]
(java.lang.NumberFormatException) 140.755
What could be causing this error?