Hi Ben, the scenario that I was trying to test was all sstables (deleted) from one node. So I did what you suggested (rebuild the sstables from other replicas in the cluster) and it rebuilt the sstables successfully.
I think the reason that I didn't see the sstables rebuilt earlier on was because I didn't use the -full option of the "nodetool rebuild". Thanks! Regards, Mike Yeap On Thu, May 19, 2016 at 4:03 PM, Ben Slater <ben.sla...@instaclustr.com> wrote: > Use nodetool listsnapshots to check if you have a snapshot - in default > configuration, Cassandra takes snapshots for operations like truncate. > > Failing that, is it all sstables from all nodes? In this case, your data > has gone I’m afraid. If it’s just all sstables from one node then running > repair will rebuild the sstables from the other replicas in the cluster. > > Cheers > Ben > > On Thu, 19 May 2016 at 17:57 Mike Yeap <wkk1...@gmail.com> wrote: > >> Hi all, I would like to know, is there any way to rebuild a particular >> column family when all the SSTables files for this column family are >> missing?? Say we do not have any backup of it. >> >> Thank you. >> >> Regards, >> Mike Yeap >> > -- > ———————— > Ben Slater > Chief Product Officer, Instaclustr > +61 437 929 798 >