You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Aleksey Plekhanov (Jira)" <ji...@apache.org> on 2020/07/22 06:05:00 UTC
[jira] [Updated] (IGNITE-12852) Comma in field is not supported by
COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aleksey Plekhanov updated IGNITE-12852:
---------------------------------------
Fix Version/s: (was: 2.9)
2.10
> 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
> Assignee: YuJue Li
> Priority: Critical
> Fix For: 2.10
>
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> 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)