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 <
sjoerd@acm.org>
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) <ping.gao@corp.elong.com> 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
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list