[CASSANDRA-10854] cqlsh COPY FROM csv having line with more than one consecutive ',' delimiter is throwing 'list index out of range'

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.1.13, 2.2.5, 3.0.3, 3.2
• Component/s: Legacy/Tools

Environment

cqlsh 5.0.1 | Cassandra 2.1.11.969 | DSE 4.8.3 | CQL spec 3.2.1

• Severity: Low
• Since Version: 2.1.11
• Assignee: Stefania Alborghetti
• Reporter: Puspendu Banerjee

Authors

Stefania Alborghetti

Reviewers

Paulo Motta

• Created: 13/Dec/15 05:10
• Updated: 16/Apr/19 09:30
• Resolved: 23/Dec/15 18:25

Description

cqlsh COPY FROM csv having line with more than one consecutive ',' delimiter is throwing 'list index out of range'

Steps to re-produce:

CREATE TABLE tracks_by_album (
  album_title TEXT,
  album_year INT,
  performer TEXT STATIC,
  album_genre TEXT STATIC,
  track_number INT,
  track_title TEXT,
  PRIMARY KEY ((album_title, album_year), track_number)
);

Create a file: tracks_by_album.csv having following 2 lines :

album,year,performer,genre,number,title
a,2015,b c d,e f g,,

cqlsh> COPY music.tracks_by_album
     (album_title, album_year, performer, album_genre, track_number, track_title)
FROM '~/tracks_by_album.csv'
WITH HEADER = 'true';

Error :
Starting copy of music.tracks_by_album with columns ['album_title', 'album_year', 'performer', 'album_genre', 'track_number', 'track_title'].

list index out of range
Aborting import at record #1. Previously inserted records are still present, and some records after that may be present as well.