[
https://issues.apache.org/jira/browse/CASSANDRA-11574?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15251194#comment-15251194
]
Stefania commented on CASSANDRA-11574:
--------------------------------------
Try using this command: {{copy ks.movie (movieid, moviename, releasedyear) from
'movies.csv';}}. Otherwise the columns in the table and file do not match and
it should fail, as expected, with {{Failed to import 1 rows: ParseError -
invalid literal for int() with base 10: 'Sabrina', given up without retries}}
and so forth for each row.
To see the column order in the table you can issue {{DESCRIBE TABLE
table_name}}. The release year is moved to the first column because it is the
partition key, even though it is the third column in the CREATE TABLE command.
Assuming the column names are specified, then it works fine for me. Could you
confirm? If it still fails, what if your Python implementation and version?
> COPY FROM command in cqlsh throws error
> ---------------------------------------
>
> Key: CASSANDRA-11574
> URL: https://issues.apache.org/jira/browse/CASSANDRA-11574
> Project: Cassandra
> Issue Type: Bug
> Components: CQL
> Environment: Operating System: Ubuntu Server 14.04
> JDK: Oracle JDK 8 update 77
> Python: 2.7.6
> Reporter: Mahafuzur Rahman
> Assignee: Stefania
> Fix For: 3.0.6
>
>
> Any COPY FROM command in cqlsh is throwing the following error:
> "get_num_processes() takes no keyword arguments"
> Example command:
> COPY inboxdata
> (to_user_id,to_user_network,created_time,attachments,from_user_id,from_user_name,from_user_network,id,message,to_user_name,updated_time)
> FROM 'inbox.csv';
> Similar commands worked parfectly in the previous versions such as 3.0.4
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
