Re: [MonetDB-users] Preferred bulk load method?

On Wed, Nov 28, 2007 at 02:20:10PM -0700, m h wrote:

On Nov 28, 2007 2:18 PM, m h wrote:

...

...

The data is confidential, let me try to create some non-confidential example....

CREATE TABLE bulk2 ( id NUMERIC(9, 0) NOT NULL, fax NUMERIC(10, 0), phone NUMERIC(10, 0), acctnum NUMERIC(7, 0), PRIMARY KEY (vendnum) );

/tmp/bulk.csv 1001||1231231234|1001 1002|1234|1231231235|1002

COPY 2 RECORDS INTO bulk_load from '/tmp/bulk.csv' USING DELIMITERS '|', '\n';

!SQLException:sql:decimal wrong format (1231231234|1001) !SQLException:sql:value 1231231234|1001 from line 0 not inserted !SQLException:importTable:failed to import table Timer 1.114 msec 0 rows

sorry bulk_load should be bulk2.... ie COPY 2 RECORDS INTO bulk2 from '/tmp/bulk.csv' USING DELIMITERS '|', '\n';

thanks for the bug, fix is coming soon. Could you next time report it on the sourceforge bugtracker? For now to work arround the problem, use INT and BIGINT types instead of numeric(x,0). And specify a NULL for nulls. Niels

------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net 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: Niels.Nes@cwi.nl