You need to use the correct record delimiter i.e. newline instead of space.


-------- Original message --------
From: Mahmoud Mohsen <mmohsen35@gmail.com>
Date: 8/18/17 19:40 (GMT+01:00)
To: users-list@monetdb.org
Subject: Re: Re: failed to import record too long: Loading 1.5 Terabyte table

Dear Stefan,

Thank you very much for your quick reply,

so this is the first line of the file "lineitem.tbl", so no need to use an offset I think

1|310378689|15378705|1|17|29786.89|0.04|0.02|N|O|1996-03-13|1996-02-12|1996-03-22|DELIVER IN PERSON|TRUCK|egular courts above the|

as for the version, I am using: MonetDB Database Server Toolkit v1.1 (Dec2016-SP5).

So can this may be the cause of the error... an old version?

I am looking forward hearing from you,


Best regards,

Mahmoud Mohsen