You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Nikolay Izhikov (Jira)" <ji...@apache.org> on 2020/05/20 08:47:00 UTC

[jira] [Commented] (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:comment-tabpanel&focusedCommentId=17111936#comment-17111936 ] 

Nikolay Izhikov commented on IGNITE-12852:
------------------------------------------

Hello, [~liyuj] It seems there is no chance for this fix to squeeze into 2.8.1 scope. So I moved it into 2.9.

> 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.9
>
>          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)