[MonetDB-users] how to load NaN as REAL

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