Good analysis of how the different key structures affect use cases and performance. I think you could extend this article with potential evaluation of FiloDB which specifically tries to solve the OLAP issue with arbitrary queries.
Another option is leveraging Elassandra (index in Elasticsearch collocates with C*) or DataStax (index in Solr collocated with C*) I personally haven’t used SnappyData but that’s another Spark based DB that could be leveraged for performance real-time queries on the OLTP side. Rahul On Aug 23, 2018, 2:48 AM -0500, Affan Syed <as...@an10.io>, wrote: > Hi, > > we wrote a blog about some of the results that engineers from AN10 shared > earlier. > > I am sharing it here for greater comments and discussions. > > http://www.an10.io/technology/cassandra-and-iot-queries-are-they-a-good-match/ > > > Thank you. > > > > - Affan