Chris Lohfink created CASSANDRA-15570:
-----------------------------------------
Summary: Change name of table metrics virtual table percentile
columns
Key: CASSANDRA-15570
URL: https://issues.apache.org/jira/browse/CASSANDRA-15570
Project: Cassandra
Issue Type: Improvement
Reporter: Chris Lohfink
The column names {{50th}} and {{90th}} are difficult to query as a selector or
in aggregation functions since our parser expects a letter for initial char. It
currently requires quoting like:
{code:sql}
SELECT table_name, "50th_ms", "99th_ms" FROM system_views.local_read_latency
{code}
Which is kinda difficult and non obvious, the error we give when not quoted
also isnt that helpful. Since it is percentile a simple thing is to just ad a p
infront:
{code:sql}
SELECT table_name, p50th_ms, p99th_ms FROM system_views.local_read_latency
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
