Hi all, I was looking into compaction and had a query regarding the same. If you have auto compaction turned on and the threshold level is 4,3 Now try loading data 7 times which will make 7 segments. Now as the auto compaction was on therefore 4 segments will be merged to 0.1. The segments visible will be 0.1, 4, 5, 6.
When i try to run the compaction command nothing happens because the threshold level is not reached for compaction to happen. What if i want to merge the 3 segments i.e (4, 5, 6) and make a level-1 compacted segment. The proposed solution would be to add a new option to the compaction command which contains what level of compaction the user would like to do Example:- alter table carbon_table compact 'minor' level '1'. This would forcefully combine the segments(4, 5, 6) in to a level 1 compacted segment called 4.1 giving me 2 level-1 compacted segment (0.1 and 4.1) Similar operation can be done with level-1 compacted segments.
