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.
I'll post a bug report.
-david
On Fri, Jan 6, 2012 at 4:22 PM, bigu
<chordata12@gmail.com> wrote:
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