Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-7639

Cqlsh cannot use .csv files exported by Excel

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Low
    • Resolution: Won't Fix
    • Fix Version/s: 1.2.19, 2.0.10, 2.1.1
    • Component/s: Legacy/Tools
    • Labels:
    • Environment:

      Mac OSX

    • Severity:
      Low

      Description

      When performing COPY table FROM 'test.csv' on cqlsh across any of the three major branches (1.2, 2.0, 2.1), the following error is thrown:

      new-line character seen in unquoted field - do you need to open the file in universal-newline mode?

      This happens if the .csv file has windows style line endings, such as if it was created by saving a .csv from excel. This reproduces in both unix and windows environments. This is a simple enough fix. I found that running dos2unix on csv files generated by excel was not sufficient to correct the issue.

        Attachments

        1. 7639-repro.csv
          0.0 kB
          Philip Thompson

          Activity

            People

            • Assignee:
              JoshuaMcKenzie Joshua McKenzie
              Reporter:
              philipthompson Philip Thompson
              Authors:
              Joshua McKenzie
              Tester:
              Philip Thompson
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: