Re: [MonetDB-users] load CSV without header row

Thank you it worked. Now i have different issue of NaN not being able to load. David Pennell-2 wrote:

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 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

------------------------------------------------------------------------------ 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

-- View this message in context: http://old.nabble.com/load-CSV-without-header-row-tp33096188p33107778.html Sent from the monetdb-users mailing list archive at Nabble.com.