Re: [jira] [Created] (IGNITE-12852) Comma in field is not supported by COPY command
Hi Anton, I have paid attention to the issue of IGNITE-7537, because it is now closed and there is no task assignment, so I created a new ticket. This issue brings a lot of trouble to data migration, many original fields are separated by commas. If it is only to solve the problem of comma separation in one field, I think it is relatively simple,so I want to solve this issue.However, according to the definition of ignite-7537, the relevant functions are still very complete, and I think it needs a lot of work. Now that you have done a lot of work in this area, I think it's better for you to continue to do so.However, as far as I'm concerned, it's a serious bug that the copy command doesn't support commas in one field, while other customization options are just function perfection, which doesn't affect the use. Anyway, thank you very much for your work. 在 2020/4/10 下午5:13, akurbanov 写道: Hello, Apologies for missing the thread, I am already working on this issue under the scope of the closed ticket, which I have missed to notify about: https://issues.apache.org/jira/browse/IGNITE-7537. I have already fixed the parsing of quotes/field delimiters but there is a bit more to implement the parser according to RFC4180 and some additional features (CRLF in the fields, for example) and some other usability features like custom delimiters, quotes. Would you like to have a discussion on the CSV parsing and scope of this ticket and take a look on my PR? Will prepare it today shortly. Best regards, Anton -- Sent from: http://apache-ignite-developers.2346864.n4.nabble.com/
Re: [jira] [Created] (IGNITE-12852) Comma in field is not supported by COPY command
Hello, Apologies for missing the thread, I am already working on this issue under the scope of the closed ticket, which I have missed to notify about: https://issues.apache.org/jira/browse/IGNITE-7537. I have already fixed the parsing of quotes/field delimiters but there is a bit more to implement the parser according to RFC4180 and some additional features (CRLF in the fields, for example) and some other usability features like custom delimiters, quotes. Would you like to have a discussion on the CSV parsing and scope of this ticket and take a look on my PR? Will prepare it today shortly. Best regards, Anton -- Sent from: http://apache-ignite-developers.2346864.n4.nabble.com/
Re: [jira] [Created] (IGNITE-12852) Comma in field is not supported by COPY command
Hello! I have added you to Contributors role. You can assign issues to yourself. Please make sure to read https://cwiki.apache.org/confluence/display/IGNITE/How+to+Contribute Regards, -- Ilya Kasnacheev чт, 9 апр. 2020 г. в 16:29, 18624049226 <18624049...@163.com>: > Hi community, > > I would like to start contributing with this issue, could someone please > add me to contributors list? My login forhttps://issues.apache.org/ is > liyuj. > > 在 2020/4/1 下午9:38, YuJue Li (Jira) 写道: > > YuJue Li created IGNITE-12852: > > - > > > > Summary: Comma in field is not supported by COPY command > > Key: IGNITE-12852 > > URL: > https://issues.apache.org/jira/browse/IGNITE-12852 > > Project: Ignite > >Issue Type: Bug > >Components: sql > > Affects Versions: 2.8 > > Reporter: YuJue Li > > Fix For: 2.8.1 > > > > > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > > > a.csv: > > 1,"a,b",2 > > > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > > > The copy command fails because there is a comma in the second field,but > this is a fully legal and compliant CSV format > > > > > > > > -- > > This message was sent by Atlassian Jira > > (v8.3.4#803005) > >
Re: [jira] [Created] (IGNITE-12852) Comma in field is not supported by COPY command
Hi community, I would like to start contributing with this issue, could someone please add me to contributors list? My login forhttps://issues.apache.org/ is liyuj. 在 2020/4/1 下午9:38, YuJue Li (Jira) 写道: YuJue Li created IGNITE-12852: - Summary: Comma in field is not supported by COPY command Key: IGNITE-12852 URL: https://issues.apache.org/jira/browse/IGNITE-12852 Project: Ignite Issue Type: Bug Components: sql Affects Versions: 2.8 Reporter: YuJue Li Fix For: 2.8.1 CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); a.csv: 1,"a,b",2 COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; The copy command fails because there is a comma in the second field,but this is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (IGNITE-12852) Comma in field is not supported by COPY command
YuJue Li created IGNITE-12852: - Summary: Comma in field is not supported by COPY command Key: IGNITE-12852 URL: https://issues.apache.org/jira/browse/IGNITE-12852 Project: Ignite Issue Type: Bug Components: sql Affects Versions: 2.8 Reporter: YuJue Li Fix For: 2.8.1 CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); a.csv: 1,"a,b",2 COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; The copy command fails because there is a comma in the second field,but this is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.3.4#803005)