So this would need me to know the partition keys, what if I simply wanted to say delete all rows where the timestamp was older than 123456789?
Rahul Neelakantan > On Oct 16, 2014, at 6:27 PM, Tyler Hobbs <[email protected]> wrote: > > For each partition in the table, run: > > DELETE FROM mytable WHERE partitionkey=? USING TIMESTAMP 123456789 > > And it will delete everything older than or equal to 123456789 (in > microseconds since the epoch, if you're using standard timestamps). > >> On Thu, Oct 16, 2014 at 5:09 PM, Rahul Neelakantan <[email protected]> wrote: >> Does anyone know of a way to delete rows from C* 1.2.8 based on the >> timestamp (time from epoch) that is present on each column in the triplet of >> name, value and timestamp? (I do not have a separate date/timestamp column >> that I insert) >> >> Rahul Neelakantan > > > > -- > Tyler Hobbs > DataStax
