Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-15570

Change name of table metrics virtual table percentile columns

    XMLWordPrintableJSON

    Details

      Description

      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:

      SELECT table_name, "50th_ms", "99th_ms" FROM system_views.local_read_latency
      

      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:

      SELECT table_name, p50th_ms, p99th_ms FROM system_views.local_read_latency
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                cnlwsu Chris Lohfink
                Reporter:
                cnlwsu Chris Lohfink
                Authors:
                Chris Lohfink
                Reviewers:
                David Capwell
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 10m
                  10m