Is your feature request related to a problem or challenge?
Yes, this is a task of #10316. We will use the porting ProgressiveEval to optimize SortPreservingMerge
Describe the solution you'd like
In InfluxDB IOx, when the inputs of SortPreservingMerge are all sorted on the sort key and their data do not overlap, we replace SortPreservingMerge with ProgressiveEval which:
- Avoids starting all input streams at once
- Avoids having to compare any keys (doesn't actually do a merge)
We wrote about using this operator here: https://www.influxdata.com/blog/making-recent-value-queries-hundreds-times-faster/
This ticket is to port ProgressiveEval from InfluxDB to DataFusion
Describe alternatives you've considered
No response
Additional context
No response