Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

michael.fabjanski_193716 avatar image
michael.fabjanski_193716 asked Erick Ramirez answered

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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered

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:

Cheers!

Share
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

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