asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ian Maxon (Jira)" <j...@apache.org>
Subject [jira] [Created] (ASTERIXDB-2710) Incorrect CSV quote handling
Date Fri, 03 Apr 2020 21:02:00 GMT
Ian Maxon created ASTERIXDB-2710:
------------------------------------

             Summary: 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


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)

Mime
View raw message