Do you want to map the NaN's to NULL's? On Mon, Jan 9, 2012 at 1:38 PM, Sjoerd Mullender <sjoerd@acm.org> wrote:

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

------------------------------------------------------------------------------ Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users