[jira] [Commented] (CASSANDRA-6910) Better table structure display in cqlsh
[ https://issues.apache.org/jira/browse/CASSANDRA-6910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14065162#comment-14065162 ] Robert Stupp commented on CASSANDRA-6910: - note: the colors are ok - they work on dark and bright terminal background colors Better table structure display in cqlsh --- Key: CASSANDRA-6910 URL: https://issues.apache.org/jira/browse/CASSANDRA-6910 Project: Cassandra Issue Type: Improvement Components: Tools Reporter: Tupshin Harper Assignee: Mihai Suteu Priority: Minor Labels: lhf Attachments: 6910.txt, cassandra6910.patch, screenshot-mihai.jpg 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)) ) -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Commented] (CASSANDRA-6910) Better table structure display in cqlsh
[ https://issues.apache.org/jira/browse/CASSANDRA-6910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14065636#comment-14065636 ] Jonathan Ellis commented on CASSANDRA-6910: --- committed. thanks, Mihai and Robert! Better table structure display in cqlsh --- Key: CASSANDRA-6910 URL: https://issues.apache.org/jira/browse/CASSANDRA-6910 Project: Cassandra Issue Type: Improvement Components: Tools Reporter: Tupshin Harper Assignee: Mihai Suteu Priority: Minor Labels: lhf Fix For: 2.1.1 Attachments: 6910.txt, cassandra6910.patch, screenshot-mihai.jpg 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)) ) -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Commented] (CASSANDRA-6910) Better table structure display in cqlsh
[ https://issues.apache.org/jira/browse/CASSANDRA-6910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14063284#comment-14063284 ] Mihai Suteu commented on CASSANDRA-6910: the colouring also works for the expanded view. When no rows are returned the normal header is displayed, even if expanded is on. Better table structure display in cqlsh --- Key: CASSANDRA-6910 URL: https://issues.apache.org/jira/browse/CASSANDRA-6910 Project: Cassandra Issue Type: Improvement Components: Tools Reporter: Tupshin Harper Priority: Minor Labels: lhf Attachments: cassandra6910.patch, screenshot-mihai.jpg 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)) ) -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Commented] (CASSANDRA-6910) Better table structure display in cqlsh
[ https://issues.apache.org/jira/browse/CASSANDRA-6910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14063588#comment-14063588 ] Robert Stupp commented on CASSANDRA-6910: - Yes - I can review tomorrow. Better table structure display in cqlsh --- Key: CASSANDRA-6910 URL: https://issues.apache.org/jira/browse/CASSANDRA-6910 Project: Cassandra Issue Type: Improvement Components: Tools Reporter: Tupshin Harper Assignee: Mihai Suteu Priority: Minor Labels: lhf Attachments: cassandra6910.patch, screenshot-mihai.jpg 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)) ) -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Commented] (CASSANDRA-6910) Better table structure display in cqlsh
[
https://issues.apache.org/jira/browse/CASSANDRA-6910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14039358#comment-14039358
]
Robert Stupp commented on CASSANDRA-6910:
-
Why not also use distinct colors for PK, CK and other columns with {{DESCRIBE
TABLE}} ?
Better table structure display in cqlsh
---
Key: CASSANDRA-6910
URL: https://issues.apache.org/jira/browse/CASSANDRA-6910
Project: Cassandra
Issue Type: Improvement
Components: Tools
Reporter: Tupshin Harper
Priority: Minor
Labels: lhf
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))
)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
