cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-4881) Force provided columns in clustering key order in 'CLUSTERING ORDER BY'
Date Wed, 31 Oct 2012 13:49:12 GMT

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

Jonathan Ellis commented on CASSANDRA-4881:
-------------------------------------------

LGTM.

Nit: "Too many columns" check could be moved out of the for loop for greater clarity.
                
> Force provided columns in clustering key order in 'CLUSTERING ORDER BY'
> -----------------------------------------------------------------------
>
>                 Key: CASSANDRA-4881
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4881
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 1.2.0 beta 1
>            Reporter: Patrick McFadin
>            Assignee: Sylvain Lebresne
>             Fix For: 1.2.0 beta 2
>
>         Attachments: 4881.txt
>
>
> Using this table:
> CREATE TABLE video_event (
>   videoid_username varchar,
>   event varchar,
>   event_timestamp timestamp,
>   video_timestamp timestamp,
>   PRIMARY KEY (videoid_username, event, event_timestamp)
> )WITH CLUSTERING ORDER BY (event_timestamp DESC);
> Inserting these records:
> INSERT INTO video_event (videoid_username, event, event_timestamp, video_timestamp) 
> VALUES ('99051fe9-6a9c-46c2-b949-38ef78858dd0:ctodd','start','2012-09-02 18:05:00','2012-09-02
18:05:00');
> INSERT INTO video_event (videoid_username, event, event_timestamp, video_timestamp) 
> VALUES ('99051fe9-6a9c-46c2-b949-38ef78858dd0:ctodd','stop','2012-09-02 18:05:30','2012-09-02
18:05:30');
> INSERT INTO video_event (videoid_username, event, event_timestamp, video_timestamp) 
> VALUES ('99051fe9-6a9c-46c2-b949-38ef78858dd0:ctodd','start','2012-09-02 18:35:00','2012-09-02
18:35:00');
> INSERT INTO video_event (videoid_username, event, event_timestamp, video_timestamp) 
> VALUES ('99051fe9-6a9c-46c2-b949-38ef78858dd0:ctodd','stop','2012-09-02 18:37:30','2012-09-02
18:37:30');
> Running this select:
> select * from video_event where videoid_username = '99051fe9-6a9c-46c2-b949-38ef78858dd0:ctodd'
limit 1;
> I get this:
>  videoid_username                           | event | event_timestamp          | video_timestamp
> --------------------------------------------+-------+--------------------------+--------------------------
>  99051fe9-6a9c-46c2-b949-38ef78858dd0:ctodd | start | 2012-09-02 18:05:00+0000 | 2012-09-02
18:05:00+0000
> I would expect to see this:
>  videoid_username                           | event | event_timestamp          | video_timestamp
> --------------------------------------------+-------+--------------------------+--------------------------
>  99051fe9-6a9c-46c2-b949-38ef78858dd0:ctodd |  stop | 2012-09-02 18:37:30+0000 | 2012-09-02
18:37:30+0000
> where the first record pulled was the sorted record by event_timestamp in reverse order.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message