You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Jonathan Ellis (JIRA)" <ji...@apache.org> on 2014/05/21 05:32:38 UTC
[jira] [Commented] (CASSANDRA-7274) Better display table
organization on desc table via primary key list
[ https://issues.apache.org/jira/browse/CASSANDRA-7274?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14004286#comment-14004286 ]
Jonathan Ellis commented on CASSANDRA-7274:
-------------------------------------------
I have no strong feelings here. WDYT [~thobbs] [~brandon.williams] [~mishail]?
> Better display table organization on desc table via primary key list
> --------------------------------------------------------------------
>
> Key: CASSANDRA-7274
> URL: https://issues.apache.org/jira/browse/CASSANDRA-7274
> Project: Cassandra
> Issue Type: Improvement
> Reporter: G Gordon Worley III
>
> In cqlsh, the desc table command does not make it sufficiently clear which columns are part of the row key and which are clustering keys.
> A simple change to the primary key list, though, would make it easier to tell.
> Consider the following table definition:
> {code}
> create table my_table {
> first_column text,
> second_column text,
> third_column text,
> primary key (first_column, second_column, third_column)
> }
> {code}
> This table has a row key of first_column and clustering keys of second_column, third_column. But if the user intended for the table to have all three in the row key, the correct definition would be:
> {code}
> create table my_table {
> first_column text,
> second_column text,
> third_column text,
> primary key ((first_column, second_column, third_column))
> }
> {code}
> But this is a sufficiently subtle difference that the first may be mistaken for the second or vice-versa.
> My suggested solution is to always wrap the row key in parentheses. This is already supported by create table syntax, so it's just a matter of changing desc table to display the create table statement with the primary key always in parentheses, like so:
> {code}
> create table my_table {
> first_column text,
> second_column text,
> third_column text,
> primary key ((first_column), second_column, third_column)
> }
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)