Re: COPY INFO Exception

Hai, looks like it works for me: $ cat /tmp/test.csv "test1","test2","test3","test4" "test5","test6","test7","test8" $ mclient -s 'create table t (s1 varchar(10), s2 varchar(10), s3 varchar(10), s4 varchar(10));' operation successful $ mclient -s "copy 3 records into t from '/tmp/test.csv' using delimiters ',','\\n','\"'" 2 affected rows $ mclient -s 'select * from t;' +-------+-------+-------+-------+ | s1 | s2 | s3 | s4 | +=======+=======+=======+=======+ | test1 | test2 | test3 | test4 | | test5 | test6 | test7 | test8 | +-------+-------+-------+-------+ 2 tuples Which version of MonetDB are you using? I’m using: $ hg branch Dec2016 $ hg head . changeset: 62466:b19c518bbe33 branch: Dec2016 user: Sjoerd Mullender date: Fri Dec 23 10:42:32 2016 +0100 summary: Remove carriage returns. If your problem persists, please provide us the schema and sample data to reproduce the problem. Regards, Jennie

On 26 Dec 2016, at 10:11, ping gao 高平(0) wrote:

Hi ALL I encountered a problem using a COPY INFO

The command to execute: [hotel@02 data_visual_monetdb]$ mclient -u monetdb -d hotel-revenue -s "COPY 1727300 RECORDS INTO hotel_revenue_octopus_hotel_info FROM '/home/ping.gao/data_visual_monetdbinfo.data' USING DELIMITERS ',','\\n','\"'" password: Failed to import table Leftover data '"0”'

Data Format(Line separator —> \n):

“test”,”test”,”test”,”test”

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list