[
https://issues.apache.org/jira/browse/CASSANDRA-8127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14174858#comment-14174858
]
Jens Rantil commented on CASSANDRA-8127:
----------------------------------------
> This has been supported for ages using EXPAND ON.
Good news! I just found the documentation (for anyone curious):
http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/expand.html
> Support vertical listing in cqlsh
> ---------------------------------
>
> Key: CASSANDRA-8127
> URL: https://issues.apache.org/jira/browse/CASSANDRA-8127
> Project: Cassandra
> Issue Type: Wish
> Components: Tools
> Reporter: Jens Rantil
> Priority: Minor
> Labels: cqlsh
>
> 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:
> {noformat}
> 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)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
