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.