[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
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.
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
participants (3)
-
bigu -
David Pennell -
Sjoerd Mullender