Re: [MonetDB-users] how to load NaN as REAL

On 2012-01-09 17:57, bigu wrote:

I have a csv file and some columns are defined as REAL. The values some time have 'NaN' so when trying to load in the db it says cannot load NaN into REAL.

COPY 1000000 OFFSET 2 RECORDS into mytable from 'C:\temp.csv' delimiters ',', '\n';

SQLException:importTable:value 'NaN' from line 11 field 10 not inserted, expecting type real failed to import table

NaN support in MonetDB is currently very poor to non-existent. It is probably possible to produce them, but it looks like importing NaNs is not possible, and it is also likely that calculations involving NaNs don't work as well as one might wish. -- Sjoerd Mullender