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