Apache Cassandra COPY TO command failing with errors={}, last_host=10.19.2.3226.81 rows/s

1
votes

I am attempting to copy the contents of one table to another (to recreate the partition key) using the COPY TO command via cqlsh. However, it gets so far (typically circa 50,000 records) and then fails with the following error:

[cqlsh 5.0.1 | Cassandra 2.1.9.791 | DSE 4.8.0 | CQL spec 3.2.0 | Native protocol v3]

cqlsh> COPY keyspace_name.flat_timeseries TO 'test.csv';

errors={}, last_host=10.19.2.3226.81 rows/s

This table contains approx 5M records - so not getting anywhere near to the end of the process.

Any ideas gratefully received.

Thanks Neil

1
cassandradatastaxdatastax-enterprisecqlsh

1 Answers

0
votes

This bug was fixed in cassandra 2.1.14 and above CASSANDRA-11053

You can use other utility like SSTableLoader