Let's say that after taking a snapshot, one of our tables ends up with corrupted data for a particular user. The application team fixes the problem on their end, and simply asks for us to restore the logins_by_user table to the last snapshot.
First of all, let's take a look at the data in question:
cassdba@cqlsh> use packt ; cassdba@cqlsh:packt> SELECT * FROM logins_by_user WHERE user_id='avery' LIMIT 1; user_id | login_datetime | origin_ip ---------+---------------------------------+----------- avery | 1970-01-01 19:48:33.945000+0000 | 10.0.15.2 (1 rows)
Obviously, the new user did not recently log in on January 1, 1970, so our corrupted data has been presented to us. To ensure that we are starting from a clean ...