At application level, you’ll probably retry, and you’ll probably select with the same cl you’ve written with. The other behaviour you’re talking about is hinte

At application level, you’ll probably retry, and you’ll probably select with the same cl you’ve written with. The other behaviour you’re talking about is hinted handoff. “So much fun to maintain” -> cassandra has very specific use cases. And hosted versions exist. Disclosure: I work at Aiven, which has an hosted cassandra offer.