On Thu, Oct 16, 2014 at 5:32 PM, Rahul Neelakantan wrote:
> 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?
You can't. You'll need to loop over the table and collect the keys.
--
Tyler Hobbs
Data
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 wrote:
>
> For each partition in the table, run:
>
> DELETE FROM mytable WHERE partitio
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 wrot
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