cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefania (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-11574) COPY FROM command in cqlsh throws error
Date Thu, 21 Apr 2016 03:46:25 GMT

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

Stefania edited comment on CASSANDRA-11574 at 4/21/16 3:46 AM:
---------------------------------------------------------------

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 is your Python implementation and version?


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

Mime
View raw message