Can you expand on why Cassandra is not good for analytics? Is that because you have to think of the queries before designing the data model? Or perhaps there are other issues?
it isn't very good for aggregation of data. It doesnt provide core functionality that you need for analytics such as grouping, joining etc. The way to achieve this is to know what analysis you want to do before you store the data, which isnt practical for different types of analysis on the same dataset