any tips to COPY INTO from a csv with whitespace around some DOUBLE fields?
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'.
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!
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
thank you for this, niels! looks like i'll have to import everything as strings and CAST afterwards :)
On Wed, Oct 1, 2014 at 8:58 AM, Niels Nes Niels.Nes@cwi.nl wrote:
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
participants (2)
-
Anthony Damico -
Niels Nes