Is there a way with cqlsh or with the Solr http api to remove all rows/documents in a given column family (or entire keyspace) that are older than a given timestamp? If so, what is the recommended way to do it?
I've been wrestling with the CQL syntax in cqlsh for hours and am giving up. From the "help" for the DELETE command, I see that there's a "USING TIMESTAMP" option, but for the life of me I can't figure out how to actually use it. Extensive searching has brought up little more than is given in the help.
All I've found indicates that there should be some way to use it in this form:
"DELETE ... USING TIMESTAMP <timestamp>;"
"DELETE * from <cf_name> USING TIMESTAMP <timestamp>;"
but I get a cryptic "expecting K_WHERE" message. So I try
"DELETE * from <cf_name> USING TIMESTAMP <timestamp> WHERE key='<value>';"
just to see if I can get something to work, but then I just get the equally helpful message
"extraneous input '*' expecting K_FROM"