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