CREATE TABLE test.txn_msgs ( id uuid PRIMARY KEY, consumed int, consumed_at timestamp, created_at timestamp, msg text, partition int, updated_at timestamp )
I Have a 3 node cluster running in prod, The above mentioned table is having millions of records in which I want to purge the data continuously which contain 1 in `consumed` column.
How I can achieve that without affecting the cluster performance.