Copy command tries to export all rows in the table, not just the ones on the node. It will eventually timeout if the table is large. It is really built for something under 5 million rows or so. Dsbulk (from DataStax) is great for this, if you are a customer. Otherwise, you will probably need to write an extract of some kind. You can get keys from the sstables, then dedupe, then export rows one by one using the keys (kind of painful). How large is the table you are trying to export?
Sean Durity From: Hossein Ghiyasi Mehr <ghiyasim...@gmail.com> Sent: Saturday, September 21, 2019 8:02 AM To: user@cassandra.apache.org Subject: [EXTERNAL] Cassandra Export error in COPY command Hi all members, I want to export (pk, another_int_column) from single node using COPY command. But after about 1h 45m, I've got a lot of read errors: [cid:image002.png@01D57199.74B91800] I tried this action many times but after maximum 2h, it failed with the errors. Any idea may help me! Thanks. ________________________________ The information in this Internet Email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this Email are subject to the terms and conditions expressed in any applicable governing The Home Depot terms of business or client engagement letter. The Home Depot disclaims all responsibility and liability for the accuracy and content of this attachment and for any damages or losses arising from any inaccuracies, errors, viruses, e.g., worms, trojan horses, etc., or other items of a destructive nature, which may be contained in this attachment and shall not be liable for direct, indirect, consequential or special damages in connection with this e-mail message or its attachment.
