Dear Mahmoud, how do the first two lines of your lineitem.tbl look like? If the first line is not actual data but headers, you'd need to explicitly skip that using the OFFSET feature of COPY INTO. Why we (nowadays?) get this possibly misleading error message, I don't know ... (I assume you're using the latest Jul2017-SP1 release, aren't you?) Best, Stefan ----- On Aug 18, 2017, at 11:54 AM, Mahmoud Mohsen mmohsen35@gmail.com wrote:
Hello,
I'm trying to load a table with 1.5 Terabytes of data, the command I'm using
COPY INTO lineitem FROM '/vol1/tpch-dbgen/2000/lineitem.tbl' USING DELIMITERS '|', ' ' LOCKED;
The physical memory I'm using is 256G, the swap is 2.2 terabytes, the dbfarm is located within area has 4 Terabytes of free storage.
The message I'm getting:
"Failed to import table 'lineitem', record too long"
So what could be a possible solution to this problem,
Thank you a lot in advance,
Mahmoud Mohsen
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |