I am evaluating the features of cockroach to maybe migrate data from Cassandra to Cockroach.
One thing I was wondering:
Does cockroach support the expiration of data (rows and/or cells) or will it ever support it?
Having TTLs in Cassandra is very useful for a lot of use cases. Expiring data in common SQL DBs can be very slow and painful. Especially if a small portion of data should be expired in millions or hundrets of millions of rows. Maintaining an index just to be able to discover old data produces overhead for inserts and maybe even more inefficient for distributed environments.
Not doing so requires full table scans. I don’t know how that will perform with Cockroach but for “plain old” RDBMS this can be very expensive.