Hi, your input misses the last record separator. Since the system can not know if this is an error in your input, it aborts the operation. You have to fix the csv file. regards, Martin On 02/10/14 08:31, 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 '';
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