On Thu, Oct 02, 2014 at 08:35:46AM +0200, Frik Lubbe wrote:
Hi all,
I'm new to MonetDB and ran into a bulk load error.
I have a delimited file to be loaded. Column Delimiter : '~' Quote Char : ' " ' (double quote) Row Delimiter: '\n'
My load script is this:
sql>COPY 1000 RECORDS INTO voc.dim_anonymous_wallets FROM '/tmp/ monetdb/201409_BA_ANON_WALLETS.SML' USING DELIMITERS '\~','\\n','\"' NULL AS ''; Did you try
COPY 1000 RECORDS INTO voc.dim_anonymous_wallets FROM '/tmp/ monetdb/201409_BA_ANON_WALLETS.SML' USING DELIMITERS '~','\n','"' NULL AS ''; Niels
Error: Incomplete record at end of file. failed to import table
This file loads OK in other db engines.
Any ideas will help please.
Regards, Frik
_______________________________________________ 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