COPY INFO Exception

newer
Upgraded to lastest MonetDB, now...

ping gao 高平(0)

26 Dec 2016 26 Dec '16

9:11 a.m.

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'smb://n','\"'" password: Failed to import table Leftover data '"0”' Data Format(Line separator —> \n): “test”,”test”,”test”,”test”

Attachments:

attachment.html (text/html — 6.4 KB)

Show replies by date

Ying Zhang

30 Dec 30 Dec

2:22 p.m.

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

ping gao 高平(0)

3 Jan 3 Jan

1:04 a.m.

New subject: 【外部邮件】Re: COPY INFO Exception

Thank you for your reply. I have found the cause of the problem.Is a problem with importing data, column already contains the specified delimiter。Make a suggestion, hope unusual tips to clear the cause of the problem. Thanks again 在 2016年12月30日，下午10:22，Ying Zhang mailto:Y.Zhang@cwi.nl> 写道： 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'smb://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 mailto: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) mailto: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'smb://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.orgmailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list _______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

2915

Age (days ago)

2923

Last active (days ago)

List overview

Download

2 comments

2 participants

participants (2)

ping gao 高平(0)
Ying Zhang