Have you looked into the ReplacingMergeTree table engine? (Although we still needed to use FINAL with this one)