Using Cassandra for OLAP

Question

We are using Cassandra for OLTP DB, storing DB transactions, and evaluating requirements for reporting solution.

We are evaluating using Cassandra for reporting database with flattened schema.

What are the advantages/ pitfalls for using Cassandra as reporting DB?

Answer 1

It's recommended to consider using Spark in conjunction to Cassandra for OLAP.

Here is a related post on stackoverflow:

Is Cassandra for OLAP or OLTP or both?

Here is a presentation for similar use case: https://www.slideshare.net/EvanChan2/breakthrough-olap-performance-with-cassandra-and-spark