cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jaroslav KamenĂ­k <jaros...@kamenik.cz>
Subject Problem with COPY FROM/TO and counters
Date Fri, 11 Nov 2016 08:22:09 GMT
Hi guys,

we are making a simple tool which allows us to transform table
via COPY TO -> drop table -> transform schema/data -> create table -> COPY
FROM.

It works well in most cases, but we have problem with loading of counter
columns, it fails with "ParseError - argument for 's' must be a string,
 given up without retries.".
It works well if the same column is defined as int.

Are we doing something wrong or encountered C* error?


Thanks,

Jaroslav



[/tmp]$ echo
"EVT:be3bd2d0-a68d-11e6-90d4-1b2a65b8a28a,f7ce3ac0-a66e-11e6-b58e-4e29450fd577,SA,2"
> data.csv
[/tmp]$ cqlsh
Connected to WOC at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 3.10-SNAPSHOT | CQL spec 3.4.3 | Native protocol
v4]
Use HELP for help.
cqlsh> CREATE TABLE woc.table_test (
   ... object_id ascii,
   ... user_id timeuuid,
   ... counter_id ascii,
   ... count counter,
   ... PRIMARY KEY ((object_id, user_id), counter_id)
   ... );
cqlsh>quit;
[/tmp]$ cqlsh -e "copy woc.table_test(object_id, user_id, counter_id,
count) from 'data.csv';"
Using 7 child processes

Starting copy of woc.table_test with columns [object_id, user_id,
counter_id, count].
<stdin>:1:Failed to import 1 rows: ParseError - argument for 's' must be a
string,  given up without retries
<stdin>:1:Failed to process 1 rows; failed rows written to
import_woc_table_test.err
Processed: 1 rows; Rate:       1 rows/s; Avg. rate:       2 rows/s
1 rows imported from 1 files in 0.560 seconds (0 skipped).
[/tmp]$
[/tmp]$
[/tmp]$
[/tmp]$
[/tmp]$ cqlsh
Connected to WOC at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 3.10-SNAPSHOT | CQL spec 3.4.3 | Native protocol
v4]
Use HELP for help.
cqlsh> drop table woc.table_test;
cqlsh>
cqlsh> CREATE TABLE woc.table_test (
   ... object_id ascii,
   ... user_id timeuuid,
   ... counter_id ascii,
   ... count int,
   ... PRIMARY KEY ((object_id, user_id), counter_id));
cqlsh>quit;
[/tmp]$ cqlsh -e "copy woc.table_test(object_id, user_id, counter_id,
count) from 'data.csv';"
Using 7 child processes

Starting copy of woc.table_test with columns [object_id, user_id,
counter_id, count].
Processed: 1 rows; Rate:       1 rows/s; Avg. rate:       2 rows/s
1 rows imported from 1 files in 0.652 seconds (0 skipped).
[/tmp]$





//////// data

echo
"EVT:be3bd2d0-a68d-11e6-90d4-1b2a65b8a28a,f7ce3ac0-a66e-11e6-b58e-4e29450fd577,SA,2"
> data.csv


//////// table definitions, first one is with counter column, second with
int column


CREATE TABLE woc.table_test (
object_id ascii,
user_id timeuuid,
counter_id ascii,
count counter,
PRIMARY KEY ((object_id, user_id), counter_id)
);

DROP TABLE woc.table_test;

CREATE TABLE woc.table_test (
object_id ascii,
user_id timeuuid,
counter_id ascii,
count int,
PRIMARY KEY ((object_id, user_id), counter_id)
);

Mime
View raw message