You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ignite.apache.org by "YuJue Li (Jira)" <ji...@apache.org> on 2020/04/01 13:38:00 UTC
[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)
Re: [jira] [Created] (IGNITE-12852) Comma in field is not supported
by COPY command
Posted by 18624049226 <18...@163.com>.
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
Posted by akurbanov <an...@gmail.com>.
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
Posted by Ilya Kasnacheev <il...@gmail.com>.
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 <18...@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
Posted by 18624049226 <18...@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)