Hey all!
Can we have different retention times for different segments based on filename pattern?
The background is that we do not like mergerollup task as we then no longer have 1:1 segment file mapping. With merge rollup, we lose the freedom of replacing a file and regenerating segment with same name.
We want to merge our daily files into one monthly file on our own and push it to the same table. We then want to have different retention periods for daily and monthly files.