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:

This file loads OK in other db engines.

Any ideas will help please.

Regards,

Frik