You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Ali Alsuliman (Jira)" <ji...@apache.org> on 2020/11/06 17:37:00 UTC
[jira] [Updated] (ASTERIXDB-2710) Incorrect CSV quote handling
[ https://issues.apache.org/jira/browse/ASTERIXDB-2710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ali Alsuliman updated ASTERIXDB-2710:
-------------------------------------
Affects Version/s: 0.9.4.1
> Incorrect CSV quote handling
> ----------------------------
>
> Key: ASTERIXDB-2710
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2710
> Project: Apache AsterixDB
> Issue Type: Bug
> Affects Versions: 0.9.4.1
> Reporter: Ian Maxon
> Assignee: Ali Alsuliman
> Priority: Major
> Fix For: 0.9.5
>
>
> the delimited text parser chokes on this quoted input for some reason. to reproduce use this ddl:
> create type foo as closed{ messageid: string, userid: string, message: string, updated_time: string, nchar: string };
> create dataset foods(foo) primary key messageid;
> load dataset foods using localfs
> (("path"="127.0.0.1:///home/parshimers/status_synth.csv"),
> ("format"="delimited-text"),
> ("quote"="\""));
> where status_synth.csv contains:
> 1,foo,", bar",baz,1
> 2,foo,"bar",baz,2
> will error out with:
> At record: 1, field#: 4 - a quote enclosing a field needs to be placed in the beginning of that field. [IOException]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)