Is it possible to export data taking only data from a given time period?

Question

question

michael.fabjanski_193716 asked Jan 18, '21 Erick Ramirez answered Jan 19, '21

Is it possible to export data taking only data from a given time period?

Hey everyone!

Is it possible to export data to another cluster - taking only data from a given time period?

In our project, we store logs in Cassandra. We would like to migrate to a different Cassandra cluster only logs from the last year.

Thanks :)

migration

10 |1000

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

DataStax Enterprise is powered by the best distribution of Apache Cassandra ™

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.

Privacy Policy Terms of Use

Answer 1 · 2021-01-19T00:35:12Z

Erick Ramirez answered Jan 19, '21

If you can query the data from your cluster, you can export it to CSV using DataStax Bulk Loader (DSBulk). You can then use the CSV output to import into another cluster also using DSBulk.

DSBulk is open-sourced and is completely free to use.

For examples and detailed procedure, see the following references:

Docs - Unloading data examples
Docs - Loading data examples
Blog - DataStax Bulk Loader Pt. 4 — Unloading
Blog - DataStax Bulk Loader Pt. 1 — Introduction and Loading

Cheers!

Share

10 |1000

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

question