How to see the actual configuration values for apache cassandra in cqlsh?

Question

This is what I have in cassandra.yaml

prepared_statements_cache_size_mb: 500MB

Is it possible to see the actual value of that variable once you're in cqlsh?

Answer 1

Since Cassandra 4.0 you'll able to do that by reading from system_views.settings table.

See the blog post from TLP on topic of virtual tables...