I have a data model where the partition key for a lot of tables is based on time
(year, month, day, hour)
this create a hotspot in my cluster, given all the writes/reads would
go to the same node for a given hour? Or does the cassandra storage
engine also takes into account the table info like table name, when
distributing the data?
If the above model would be a problem, what's the suggested way to solve this? Add tablename to partition key?