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

[Puspendu Banerjee (JIRA)]

Puspendu Banerjee created CASSANDRA-10854:
---------------------------------------------

             Summary: cqlsh COPY FROM csv having line with more than one 
consecutive  ',' delimiter  is throwing 'list index out of range'
                 Key: CASSANDRA-10854
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-10854
             Project: Cassandra
          Issue Type: Bug
          Components: Tools
         Environment: cqlsh 5.0.1 | Cassandra 2.1.11.969 | DSE 4.8.3 | CQL spec 
3.2.1 
            Reporter: Puspendu Banerjee


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.





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)