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

28 Nov 2007


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