You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Sylvain Lebresne (JIRA)" <ji...@apache.org> on 2012/10/31 09:41:12 UTC
[jira] [Commented] (CASSANDRA-4881) Force provided columns in
clustering key order in 'CLUSTERING ORDER BY'
[ https://issues.apache.org/jira/browse/CASSANDRA-4881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13487618#comment-13487618 ]
Sylvain Lebresne commented on CASSANDRA-4881:
---------------------------------------------
I've updated the title to reflect what the patch attached actually fixes.
> 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