[CASSANDRA-17224] Add a virtual table for exposing prepared statements metrics

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 4.1-alpha1, 4.1
• Component/s: Feature/Virtual Tables, Observability/Metrics
• Labels: AdventCalendar2021 lhf
• Change Category: Operability
• Complexity: Low Hanging Fruit
• Platform: All

Source Control Link

https://github.com/apache/cassandra/commit/945a4fc23ac1f60b8380be3b60aef89caf3daba2

Test and Documentation Plan

https://github.com/apache/cassandra/pull/1421

• Assignee: Shailaja Koppu
• Reporter: Benjamin Lerer

Authors

Shailaja Koppu

Reviewers

Ekaterina Dimitrova, Francisco Guerrero, Yifan Cai

• Created: 21/Dec/21 09:06
• Updated: 27/May/22 19:25
• Resolved: 01/Feb/22 20:47

Description

There are some existing metrics within CQLMetrics that provide metrics about prepared statements. We should expose those through a virtual table.

Additional information for newcomers:

A new class should be created for representing the new Virtual Table in org.apache.cassandra.db.virtual. You can look at ThreadPoolsTable for an example.
The new table will need to be registered in SystemViewsKeyspace.
Some unit tests will need to be added. For some example of virtual table tests you can look at SystemPropertiesTableTest and for some example of test around prepared statement metrics you can look into CQLMetricsTest.