What's the best-practises liveness check for Cassandra?

Question

I have an HTTP healthcheck endpoint that checks that infrastructure dependencies such as Cassandra is up and running. For SQL databases liveness is commonly checked by executing SELECT 1. Is there an equivalent query that can be executed against Cassandra?

Answer 1

You could query for the cassandra version

SELECT release_version FROM system.local