[ 
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)

Reply via email to