Problem: we have tried 2 sensible partitioning schemes for tracking current state for a fleet of sensors--one being ((sensor_id), ...) and the other ((user_id, sensor_id) ...). Both land us with a very hot partition, and we're not in a position where we can add more nodes quickly. So, can we change the value of the partition column deliberately to send noisy sensors to another partition? Should we event attempt to? Has anyone else needed to do this?
What is the better/best practice here?