On Wed, Oct 01, 2014 at 08:04:37AM -0400, Anthony Damico wrote:
> here's the problem--
>
>
>   Unable to execute statement 'COPY 2626675 OFFSET 2 RECORDS INTO
> OPPR_ALL_DTL_GNRL_09302014 FROM 'C:\Users\anthonyd\AppData\Local\...'.
>
> Server says '!value '1  ' from line 1 field 51 not inserted, expecting
> type double'.
It seems there are extra spaces after the '1'. The copy into expects
no additional characters, ie just the double value. The string
conversion does handle this (ie thats why the load via VARCHAR works).

Is this data formatted such that each values has extra spaces, then
the 'delimiters' could be ajusted to include these extra spaces.

Niels
>
>
>
> i could import it as VARCHAR and then CAST it back into a DOUBLE type,
> but i'm wondering if anyone has an easier/more clever way to import
> this?  handling it manually would mean that i cannot use the
> monet.read.csv()  function, so it's a bit more work.  thanks!

> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list


--
Niels Nes, Centrum Wiskunde & Informatica (CWI)
Science Park 123, 1098 XG Amsterdam, The Netherlands
room L3.14,  phone ++31 20 592-4098     sip:4098@sip.cwi.nl
url: http://www.cwi.nl/~niels   e-mail: Niels.Nes@cwi.nl

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list