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

28 Nov 2007


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

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

m h