cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andy Cobley (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-6676) Add ability to see layout of storage for CQL tables
Date Fri, 07 Feb 2014 20:32:20 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-6676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13894994#comment-13894994
] 

Andy Cobley commented on CASSANDRA-6676:
----------------------------------------

Sorry guys, perhaps storage layout is a bit far, but this:

[default@keyspace2] list tweets;
Using default limit of 100
Using default cell limit of 100
-------------------
RowKey: Andy
=> (name=940634b0-3b1a-11e3-aa6e-0800200c9a66:, value=, timestamp=1391351360676000, ttl=2592000)
=> (name=940634b0-3b1a-11e3-aa6e-0800200c9a66:tweet, value=737465702033, timestamp=1391351360676000,
ttl=2592000)
=> (name=8118c700-3b1a-11e3-aa6e-0800200c9a66:, value=, timestamp=1391351360630000, ttl=2592000)
=> (name=8118c700-3b1a-11e3-aa6e-0800200c9a66:tweet, value=737465702032, timestamp=1391351360630000,
ttl=2592000)
=> (name=61647990-3b1a-11e3-aa6e-0800200c9a66:, value=, timestamp=1391351360729000, ttl=2592000)
=> (name=61647990-3b1a-11e3-aa6e-0800200c9a66:tweet, value=737465702031, timestamp=1391351360729000,
ttl=2592000)

1 Row Returned.
Elapsed time: 1123 msec(s).
[default@keyspace2] exit


Tells me a lot about whats going on form this:

CREATE TABLE Tweets (
user varchar,
 interaction_time timeuuid,
 tweet varchar,
 PRIMARY KEY (user,interaction_time)
) WITH CLUSTERING ORDER BY (interaction_time DESC);

INSERT INTO Tweets (user,interaction_time,tweet)
VALUES ('Andy',3b3250c0-8f6c-11e3-baa8-0800200c9a66,'step 4');
INSERT INTO Tweets (user,interaction_time,tweet)
VALUES ('Bill',e878d600-8f6c-11e3-baa8-0800200c9a66,'Bill step a');

> Add ability to see layout of storage for CQL tables
> ---------------------------------------------------
>
>                 Key: CASSANDRA-6676
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6676
>             Project: Cassandra
>          Issue Type: Improvement
>            Reporter: Brian ONeill
>            Priority: Minor
>
> Many of us use the CLI to see how data gets laid out in storage for tables created via
CQL.  If we intend to deprecate CLI, it would be nice to have this ability in CQL.
> See thread:
> http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/CQL-list-command-td7592673.html



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Mime
View raw message