[
https://issues.apache.org/jira/browse/CASSANDRA-10906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15242699#comment-15242699
]
Alex Petrov commented on CASSANDRA-10906:
-----------------------------------------
Couldn't reproduce it on {{2.0}}, {{2.1}} or {{3.x}}. I've "reverse-engineered"
schema and made a {{COPY}} command using information from description, although
had to add the time format.
{{code}}
CREATE TABLE testtable (SeasonType int,
Season int,
Week int,
Date timestamp,
AwayTeam text,
HomeTeam text,
Channel text,
PointSpread double,
OverUnder double,
StadiumID int,
PRIMARY KEY (SeasonType, Season , Week, Date, AwayTeam,
HomeTeam, Channel));
COPY testtable FROM '/tmp/Schedule.csv' WITH header=true and delimiter='|' and
datetimeformat='%m/%d/%Y %H:%M';
{{code}}
If you can provide more precise reproduce steps, I'd be happy to give it
another try.
> List index out of range
> -----------------------
>
> Key: CASSANDRA-10906
> URL: https://issues.apache.org/jira/browse/CASSANDRA-10906
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Environment: java version "1.8.0_66", 64-bit
> Reporter: Scott Chaffee
> Attachments: Schedule.csv
>
>
> Using COPY FROM command to import a .csv file with a header row and '|'
> delimited you get an error back "List index out of range"
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)