Niels, Perhaps I do not understand the documentation but I assumed you could run COPY into multiple times on a single table.
I am able to run COPY INTO <table> once on an empty table. If I run COPY INTO <table> again on a non-empty table I receive the error (!MALException:batmtime.EQ:Unexpected input type). I can choose any single input file and it will load properly into an empty table. I did try combining all of my input files and running that way but after 36 hours I killed the load. Colin --- Niels Nes <[EMAIL PROTECTED]> wrote: > On Sat, Apr 14, 2007 at 09:32:24AM -0700, Colin Foss > wrote: > > This is strange. Using MonetDB4 this script ran > > without error, in MonetDB5 I get this error: > > > > QUERY = copy INTO my_big_table FROM > > 'E:/data/migrate/big_table_input-ab.tab' > > ERROR = !MALException:batmtime.EQ:Unexpected input > > type > > sounds like a bug. Which version of M5/sql are you > using? The > fact that it runs fine on M4 and in 2 runs indicates > that it > maybe related too one of the m5 optimizers. These > can be controlled using the > optimizer session variable. See > http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/Optimizer-Control.html#Optimizer-Control > for more information. > > Niels > > > > always on the second input file. > > > > Here is my script: > > ------------------------------------- > > set SCHEMA myschema; > > declare fname varchar(100); > > delete from my_big_table; > > > > -- this one is good > > set fname='big_table_input-aa.tab'; > > select fname as phase; > > COPY into my_big_table from > > 'E:/data/migrate/big_table_input-aa.tab' using > > delimiters '\t','\n'; > > > > -- this one will error > > set fname='big_table_input-ab.tab'; > > select fname as phase; > > COPY into my_big_table from > > 'E:/data/migrate/big_table_input-ab.tab' using > > delimiters '\t','\n'; > > > > select 'total amount' as phase; > > select count(*) from my_big_table; > > ------------------------------------- > > > > Yet, if I run the files one at a time, the will > each > > load without error. > > > > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by DB2 Express > > Download DB2 Express C - the FREE version of DB2 > express and take > > control of your XML. No limits. Just data. Click > to get it now. > > http://sourceforge.net/powerbar/db2/ > > _______________________________________________ > > MonetDB-users mailing list > > [email protected] > > > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > -- > > Niels Nes, Centre for Mathematics and Computer > Science (CWI) > Kruislaan 413, 1098 SJ Amsterdam, The Netherlands > room C0.02, phone ++31 20 592-4098, fax ++31 20 > 592-4312 > url: http://www.cwi.nl/~niels e-mail: > [EMAIL PROTECTED] > ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ MonetDB-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-users
