Details
Normal Description
Currently system.compaction_history only contains summary information about a compaction, which is useful if users only care about when the compaction occurs and the benefits generated by the compaction. However, it does not show the detailed src->dst SSTable mappings. For example, it does not show which SSTable is created or deleted as a result of compaction. As a result, when users want to backup or archive data files, they may end up backing-up different SSTables that represent exactly the same user data.
It will be great if there is a system.compaction_detailed_history table that remembers the detailed lineage of SSTables so the backup task does not have to figure out the duplicate data on its own.
