cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Techy Teck <>
Subject Get all the data for x number of seconds from CQL?
Date Thu, 12 Dec 2013 22:28:16 GMT
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 -


And here timestamp is in milliseconds but rounded up to nearest seconds. So
as an example, data in `id column` will be like this -


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

View raw message