I have to create a report from the data present in Cassandra DB. I am more in to RDBMS and pretty much new in to Cassandra DB. In RDBMS that task is quite easy, you can create complex queries with joins and create the report. But how we can acheieve the same thing in Cassandra DB.
1 Answers
You can use the Bulk Loader (DSBulk) tool to export data from a Cassandra table.
However, it's not BI tool and there are no joins in Cassandra so you can't do complex queries. Once you've exported a table to a CSV file, you can manipulate it whichever way you want.
Here are some references with examples to help you get started quickly:
- Blog - Introduction to DSBulk
- Blog - DSBulk Unloading examples
- Docs - More data export examples
DSBulk is open-source so it's free to use. Cheers!
Related