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

Support vertical listing in cqlsh

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Low
    • Resolution: Duplicate
    • None
    • Legacy/Tools

    Description

      MySQL CLI has this neat feature that you can end queries with `\G` and it will each result row vertically. For tables with many columns, or for users with vertical screen orientation or smaller resolution, this is highly useful. Every time I start `cqlsh` I feel this feature would be highly useful for some of the tables that have many columns. See example below:

      mysql> SELECT * FROM testtable;
      +------+------+------+
      | a    | b    | c    |
      +------+------+------+
      |    1 |    2 |    3 |
      |    4 |    5 |    6 |
      |    6 |    7 |    8 |
      +------+------+------+
      3 rows in set (0.00 sec)
      
      mysql> SELECT * FROM testtable\G
      *************************** 1. row ***************************
      a: 1
      b: 2
      c: 3
      *************************** 2. row ***************************
      a: 4
      b: 5
      c: 6
      *************************** 3. row ***************************
      a: 6
      b: 7
      c: 8
      3 rows in set (0.00 sec)
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ztyx Jens Rantil
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: