2 Oct
2014
2 Oct
'14
6:31 a.m.
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 '';
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