cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Sturrock (JIRA)" <>
Subject [jira] [Created] (CASSANDRA-13609) COPY FROM not handling newlines within field
Date Thu, 15 Jun 2017 16:09:00 GMT
David Sturrock created CASSANDRA-13609:

             Summary: COPY FROM not handling newlines within field
                 Key: CASSANDRA-13609
             Project: Cassandra
          Issue Type: Bug
          Components: CQL
         Environment: CQL 5.0.1

            Reporter: David Sturrock
            Priority: Minor
             Fix For: 3.0.9

When using Copy From to import data from a CSV file, if it comes across a row like like this:

10.0, 10.0, 0.0, "UX JSY AIO PETE 
10% off Toys Catalogue 10.00% -1.00 ", "Canterbury"
10.0, 10.0,......

It will treat the newline after PETE as the end of the first row

While this makes sense since it's treating each line as a new row, it's also supposed to treat
content between "s as a field but instead finishes  half way through a field. Shouldn't the
fact that it's inside a field take precedence here and have it continue reading until it finds
a closing "?

This message was sent by Atlassian JIRA

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message