You can run file level compaction using JMX to get rid of tombstones in one
SSTable. Ensure you set GC_Grace_seconds such that
current time >= deletion(tombstone time)+ GC_Grace_seconds
File level compaction
/usr/bin/java -jar cmdline-jmxclient-0.10.3.jar - localhost:
> {
> port}
> org.apache.cassandra.db:type=CompactionManager
> forceUserDefinedCompaction="'${KEYSPACE}','${
> SSTABLEFILENAME
> }'""
>
>
On Wed, Jul 27, 2016 at 11:59 AM, sai krishnam raju potturi <
pskraj...@gmail.com> wrote:
> hi;
> we have a columnfamily that has around 1000 rows, with one row is really
> huge (million columns). 95% of the row contains tombstones. Since there
> exists just one SSTable , there is going to be no compaction kicked in. Any
> way we can get rid of the tombstones in that row?
>
> Userdefined compaction nor nodetool compact had no effect. Any ideas folks?
>
> thanks
>
>
>
