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