Re: Retrieving data between two timestamps

2013-01-15 Thread Renato Marroquín Mogrovejo
Thanks for the explanation Aaron! Renato M. 2013/1/15 Aaron Turner : > The timestamp is the time the record was inserted into the Cassandra > node. It's used for conflict resolution, so if two clients insert > different data into the same row/column, Cassandra can pick the > "winner" (most rece

Re: Retrieving data between two timestamps

2013-01-15 Thread Aaron Turner
The timestamp is the time the record was inserted into the Cassandra node. It's used for conflict resolution, so if two clients insert different data into the same row/column, Cassandra can pick the "winner" (most recent timestamp). You can set it manually on insert, otherwise the node will pick

Re: Retrieving data between two timestamps

2013-01-15 Thread Renato Marroquín Mogrovejo
Hi Aaron, Thanks for answering! Yeah that is what I did but then when looking into the actual column family created I saw this timestamp column which Cassandra had created. Are we allowed to use this? What is this specifically for? Thanks again for the help! Renato M. 2013/1/15 Aaron Turner : >

Re: Retrieving data between two timestamps

2013-01-15 Thread Aaron Turner
I don't think so. Usually you'd use either a Time-UUID or something like epoch time as the column name to get a range of columns by time range. On Tue, Jan 15, 2013 at 10:46 AM, Renato Marroquín Mogrovejo wrote: > Hi all, > > I am having some problems while retrieving some events from a column >

Retrieving data between two timestamps

2013-01-15 Thread Renato Marroquín Mogrovejo
Hi all, I am having some problems while retrieving some events from a column family I have created. My column family has been created as follows: create column family click_event WITH comparator = UTF8Type and column_metadata = [ {column_name: event, validation_class: UTF8Type} ]; My table i