Thanks for the response. We need to export into a flat file and send to another analytical application. There are 137 tables and 30 of them are have 300M+ records. So “COPY TO” taking lot of time.
Thank you Bibin John From: Aakash Pandhi <pandhiaak...@yahoo.com.INVALID> Sent: Wednesday, February 19, 2020 12:51 PM To: user@cassandra.apache.org Subject: Re: Mechanism to Bulk Export from Cassandra on daily Basis John, Greetings, Requirement is to just export data from table and stage it somewhere? OR export it and load them in another cluster/table? sstableloader is a utility which can help you as it is designed for bulk loading. Sincerely, Aakash Pandhi On Wednesday, February 19, 2020, 10:13:32 AM PST, JOHN, BIBIN <bj9...@att.com<mailto:bj9...@att.com>> wrote: Team, We have a requirement to bulk export data from Cassandra on daily basis? Table contain close to 600M records and cluster is having 12 nodes. What is the best approach to do this? Thanks Bibin John
