I have a data model where the partition key for a lot of tables is based on time
(year, month, day, hour)

Would 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?