You can use
COPY 1000000 OFFSET 2 RECORDS into mytable from 'C:\data.csv' delimiters
',', '\n';
Note that its an offset into the file with records numbers starting at 1.
The documentation at
http://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInto hints at
it, but is incomplete.
The documentation at the monetdb xquery site looks correct.
http://monetdb-xquery.org/SQL/Documentation/Data-Manipulation.html
I'll post a bug report.
-david
On Fri, Jan 6, 2012 at 4:22 PM, bigu
Today installed monetdb for first time and wanted to play with some of the features but stuck with loading the file. Excuse me if this looks too basic.
There is a 3GB csv file (1M rows and 400 columns). I am trying load in monetdb on my windows 7 machine. I first created a table mostly data is numeric exect for few that are metadata strings. How do i load this file without removing the header. The error says column_name not of type integer since the column_name is the actual header string but the values are integers. I can remove the header manually before loading but if i plan to scale then it is not a good option.
Is there a way to say load "n" records from file starting at 'x' to 'y'? or ignore first line.
COPY 1000000 RECORDS into mytable from 'C:\data.csv' delimiters ',', '\n';
Thanks. -- View this message in context: http://old.nabble.com/load-CSV-without-header-row-tp33096188p33096188.html Sent from the monetdb-users mailing list archive at Nabble.com.
------------------------------------------------------------------------------ Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users