Using Cassandra for OLAP

Question

We use Cassandra for OLTP databases, storing database transactions and evaluating reporting requirements.

We appreciate the use of Cassandra to create a flat schema database.

What are the advantages / disadvantages of using Cassandra as a reporting database?

Answer 1

It is recommended that you use Spark with Cassandra for OLAP.

Here is the related post on stackoverflow:

Is Cassandra for OLAP or OLTP or both?

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

Answer 2

Cassandra . , , . , , , Cassandra.

, , . , Cassandra. , Cassandra Cassandra. Spark Cassandra. , Spark.

Answer 3

Kassandra has no associations and aggregates, although there is UDAF ( https://docs.datastax.com/en/cql/3.3/cql/cql_using/useCreateUDA.html ), but, in my opinion, they are quite restrictive. Therefore, if you are looking for something that will allow you to be flexible in your requests, c * is not the answer (for example, special requests by analysts), since you always need client-side aggregation and aggregation. For predefined reports, I think this might work. But you must be extremely careful with the asymmetry of the partitions ...