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

Better table structure display in cqlsh

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Low
    • Resolution: Fixed
    • Fix Version/s: 2.1.1
    • Component/s: Legacy/Tools
    • Labels:

      Description

      It should be possible to make it more immediately obvious what the structure of your CQL table is from cqlsh. Two minor enhancements could go a long way:
      1) If there are no results display the column headers anyway. Right now, if you are trying to do a query and get no results, it's common to need to display the table schema to figure out what you did wrong. Having the columns displayed whenever you do a query wouldn't get in the way, and would provide a more visual way than by describing the table.

      2) Along with the first one, if we could highlight the partition/clustering columns in different colors, it would be much more intuitively
      understandable what the underlying partition structure is.

      tl;dr: the forms below should each have distinct visual representation when displaying the column headers, and the column headers should always be shown.

      CREATE TABLE usertest (
      userid text,
      email text,
      name text,
      PRIMARY KEY (userid)
      )

      CREATE TABLE usertest2 (
      userid text,
      email text,
      name text,
      PRIMARY KEY (userid, email)
      )

      CREATE TABLE usertest3 (
      userid text,
      email text,
      name text,
      PRIMARY KEY ((userid, email))
      )

        Attachments

        1. 6910.txt
          5 kB
          Robert Stupp
        2. cassandra6910.patch
          5 kB
          Mihai Suteu
        3. screenshot-mihai.jpg
          70 kB
          Mihai Suteu

          Issue Links

            Activity

              People

              • Assignee:
                xapharius Mihai Suteu
                Reporter:
                tupshin Tupshin Harper
                Authors:
                Mihai Suteu
                Reviewers:
                Robert Stupp
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: