cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alex Petrov (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-10906) List index out of range
Date Fri, 15 Apr 2016 09:38:25 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-10906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15242699#comment-15242699
] 

Alex Petrov edited comment on CASSANDRA-10906 at 4/15/16 9:37 AM:
------------------------------------------------------------------

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.


was (Author: ifesdjeen):
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)

Mime
View raw message