Bulk Load error

2 Oct 2014

      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

Frik Lubbe