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)