[ASTERIXDB-2710] Incorrect CSV quote handling - ASF JIRA

XML

Word

Printable

JSON

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]

is fixed by

ASTERIXDB-2713 Add CSV and TSV support for external dataset

is related to

ASTERIXDB-2713 Add CSV and TSV support for external dataset