Re: write time corrupted and not sure how

2017-08-17 Thread Jeff Jirsa
There are certainly cases where corruption has happened in cassandra (rare, thankfully), but like I mentioned, I'm not aware of any that only corrupted timestamps. It wouldn't surprise me to see a really broken clock, and it wouldnt' surprise me to see bit flips on bad hardware (even hardware with

Re: write time corrupted and not sure how

2017-08-17 Thread Greg Saylor
Thanks for your help, I wrote a script to cycle through these early records and try to update them (some columns were missing, but could be gleaned from another db), then do the update, re-read, and if its not correct figure out the write time and re-issue the update with a timestamp + 1. We’re

Re: write time corrupted and not sure how

2017-08-17 Thread Jeff Jirsa
It's a long, so you can't grab it with readInt - 8 bytes instead of 4 You can delete it by issuing a delete with an explicit time stamp at least 1 higher the. The timestamp on the cell DELETE FROM table USING TIMESTAMP=? WHERE https://cassandra.apache.org/doc/latest/cql/dml.html#delete T