[Question posted by a user on YugabyteDB Community Slack ]
We need to expire data using a TTL with a table that uses a secondary index. How would we remove data that currently expires using a TTL, but can’t due to the need for a secondary index?
[Question posted by a user on YugabyteDB Community Slack ]
We need to expire data using a TTL with a table that uses a secondary index. How would we remove data that currently expires using a TTL, but can’t due to the need for a secondary index?
You will need to do explicit deletes.
partition_hash
On #4, recently, I had responded thus, to a community user question:Using the partition_hash function (YCQL equivalent of the token
function in Apache Cassandra) to split the 0…64K hash space of a table is a reliable way (stable API) to partition the work among a set of worker tasks.Here’s an example python program that uses the same concept to count the total number of rows in a table using a configurable number of worker threads.https://gist.github.com/kmuthukk/5899f38a147e2ccd36ac8fc2a81ca5c7And a Go version of the same:yb-tools/ycrc at main · yugabyte/yb-tools · GitHub
#2 was addressed in issue: