My cents: You could partition your data per date and second query would be easy. If you need to query ALL data for a client id, it would be hard though, but querying last 10 days for a client id could be easy, for instance. If you need to query ALL, it would probably be better to create another CF and write on both, google for Cassandra materialized view in this case. []s
From: user@cassandra.apache.org Subject: Re:designing table I am trying to design a table in Cassandra in which I will have multiple JSON String for a particular client id. abc123 - jsonA abc123 - jsonB abcd12345 - jsonC My query pattern is going to be - Give me all JSON String for a particular client id. Give me all the client id's and json strings for a particular date. What is the best way to design table for this?