You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Ian Maxon (Jira)" <ji...@apache.org> on 2020/04/03 21:03:00 UTC
[jira] [Assigned] (ASTERIXDB-2710) Incorrect CSV quote handling
[ https://issues.apache.org/jira/browse/ASTERIXDB-2710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ian Maxon reassigned ASTERIXDB-2710:
------------------------------------
Assignee: Murtadha Makki Al Hubail
> Incorrect CSV quote handling
> ----------------------------
>
> Key: ASTERIXDB-2710
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2710
> Project: Apache AsterixDB
> Issue Type: Bug
> Reporter: Ian Maxon
> Assignee: Murtadha Makki Al Hubail
> Priority: Major
>
> 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)