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