Hello, Is there a way to stop long running queries in Cassandra (versions 3.11.x or 4.x) ? The use-case is to have some kind of a circuit breaker based on query-time that has exceeded the client's SLAs. Example: If server response is useless to the client after 10 ms, then we could have a *query_killing_timeout* set to 15 ms (where additional 5ms allows for some buffer). And when that much time has elapsed, Cassandra will kill the query execution automatically.
If this is not possible in Cassandra currently, any chance we can do it outside of Cassandra, like a shell script that monitors such long running queries (through users table etc) and kills the OS-thread responsible for that query (Looks unsafe though as that might leave the DB in an inconsistent state) ? We are trying this as a proactive measure to safeguard our clusters from any rogue queries fired accidentally or maliciously. Thanks !
