Below is my CQL table - CREATE TABLE test1 ( id text, record_name text, record_value blob, PRIMARY KEY (id, record_name) )
here id column will have data like this - timestamp.count And here timestamp is in milliseconds but rounded up to nearest seconds. So as an example, data in `id column` will be like this - 1386882930000.1 And a single row in the above table will be like this - 1386882930000.1 | event_name | hello-world Now my question is - Is it possible to get all the data for last 5 seconds or 10 seconds or 30 seconds by using the id column? I am running Cassandra 1.2.9